SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( nuke_bbforums f
LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id )
LEFT JOIN nuke_users u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order
Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.