The symantics of joining tables has changed subtly under MySQL5. They don't happen in left-to-right order; "OUTER JOIN" or "," has lower priority than LEFT JOIN. You can add parenthesis to influence this ordering. For more details, see http://dev.mysql.com/doc/refman/5.0/en/join.html . I will attach a very simple patch that fixes the instance of this that I have seen so far. This patch seems to work fine under MySQL4.0 as well, so at least that isn't a problem.
*** This bug has been marked as a duplicate of 314080 ***