select subject, forum_id
from forums_messages
where message_id=:selected_message
select tree_sortkey as father_tree_sortkey, max_child_sortkey as father_max_child_sortkey
from forums_messages
where message_id= :message_id
select message_id as father_message_id
from forums_messages
where forum_id = $message(forum_id) and tree_sortkey = '$initial_tree_sortkey'
update forums_messages
set reply_count = reply_count - 1, approved_reply_count = approved_reply_count - 1
where message_id = :father_message_id
update forums_messages
set tree_sortkey = :join_tree_sortkey
where message_id = :msge_id
update forums_messages
set reply_count = reply_count + 1, approved_reply_count = approved_reply_count + 1
where message_id = :message_id
update forums_messages
set parent_id = :message_id, tree_sortkey = :join_tree_sortkey
where message_id = $message(message_id)