[captainslater]

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 5 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL-Fehler : Column 'visible' in where clause is ambiguous
Fehler-Nr. : 1052

OS: Linux
PHP: 5.0.4
MySQL 4.1.4

Installed in forum root