SQL Error : 1054 Unknown column 't.forum_id' in 'on clause'
SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2
LEFT JOIN phpbb_forums f
ON t.forum_id=f.forum_id
WHERE t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND f.auth_view > 1
ORDER BY t.topic_last_post_id DESC
LIMIT 6 Line : 146 File : /www/htdocs/gsnabi/phpBB2/actualstats2.php
Home
