SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( battelbonfire_forums f
LEFT JOIN battelbonfire_posts p ON p.post_id = f.forum_last_post_id )
LEFT JOIN battelbonfire_users u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order