select 1 where exists ( select 1 from forums_messages where forum_id = :forum_id) select tree_sortkey from forums_messages where forum_id = :forum_id and parent_id is null order by tree_sortkey asc select tree_sortkey as message_tree_sortkey from forums_messages where message_id = $message(message_id) update forums_messages set forum_id = :forum_id, tree_sortkey = :join_tree_sortkey where message_id = :message_id update forums_forums set thread_count = :thread_count - 1, approved_thread_count = :approved_thread_count -1, last_post = (select max(fm.last_child_post) from forums_messages fm where fm.forum_id = $message(forum_id)) where forum_id = $message(forum_id) update forums_reading_info set forum_id = (select forum_id from forums_messages where message_id = $message(message_id)) where root_message_id = $message(message_id)