attempt to eliminate duplicate joins