SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0;