SELECT * FROM forum_topic WHERE parent_id = 12 ORDER BY (SELECT MAX(time) FROM forum_post WHERE parent_id = forum_topic.record_id ORDER BY time ASC) DESC LIMIT -25, 25