Quote:

SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u.user_active, u.user_color, f.forum_name
FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_users AS u, phpbb_forums AS f
WHERE t.forum_id NOT IN (2,20,28)
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
AND f.forum_id = t.forum_id

ORDER BY p.post_time DESC
LIMIT 10 |