remove the unused left join