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)