Whenever you do a left join a small table and a large table make sure that large table is defined first in the join query. In your case the query...