Okay. Another JOIN question. This time I'm trying to add two left JOINS to the same query.
Any reason why this isn't working?
PHP Code:
SELECT topics.id id, topics.theme, topics.title, topics.revised, topics.locked, topics.date, users.username, users.image, users.role, themes.id themeid, themes.name
FROM `forum topics` topics LEFT JOIN users ON users.id = topics.author
LEFT JOIN themes ON themes.id = topics.theme
WHERE slug = '{$slug}' ORDER BY topics.id LIMIT 1
If I remove the second LEFT JOIN line and ", themes.id themeid, themes.name" the query works fine.