UPDATE phpbb_topics SET topic_status = 1 WHERE topic_id IN (SELECT topic_id FROM phpbb_posts WHERE post_time <= now() - 2678400 )