UPDATE hiasm_topics t SET t.first_post = (SELECT post_id FROM hiasm_posts WHERE topic = t.topic_id ORDER BY time LIMIT 1), t.last_post = (SELECT post_id FROM hiasm_posts WHERE topic = t.topic_id ORDER BY time DESC LIMIT 1) WHERE t.forum = %forum_id%