select count(forum_id) as num_post 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 select ff.max_child_sortkey, ff.thread_count, ff.approved_thread_count from forums_forums ff where ff.forum_id = :forum_id select ff.max_child_sortkey, ff.thread_count, ff.approved_thread_count from forums_forums ff where ff.forum_id = $message(forum_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)