SELECT f.*, p.post_time, p.post_username, t.topic_id, t.topic_replies, u.username, u.user_id
FROM ((( phpbb_forums f
LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id )
LEFT JOIN phpbb_topics t ON t.topic_last_post_id = p.post_id )
LEFT JOIN phpbb_users u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order