Is there a specific reason you are using left join...