I think the problem is related to using the wrong syntax for LEFT JOIN when using MySQL 5.1

Can anyone verify this? I'm not really that good with mysql, and I've been researching but no avail.