Oh deary me.
That wasn't good. It turns out that MySQL 5 really doesn't like my lazy JOIN syntax at all. Throughout my sites I have tables joined together like:
Code: Select all
select * from user, country
LEFT JOIN privs on privs.user_id = user.user_id
WHERE
user.country_id = country.country_idCode: Select all
select * from user
INNER JOIN country ON user.country_id = country.country_id
LEFT JOIN privs ON privs.user_id = user.user_id