added the left join statement into a comment