remove a pesky left join