select ff.name, fm.subject, fm.forum_id from forums_forums ff, forums_messages fm where fm.message_id =:message_id and ff.forum_id=fm.forum_id select tree_sortkey as father_tree_sortkey, max_child_sortkey as father_max_child_sortkey from forums_messages where message_id= :message_id update forums_messages set forum_id = :forum_id, 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, forum_id = :forum_id where message_id = $message(message_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) update forums_forums set last_post = (select max(last_child_post) from forums_messages where forum_id = :forum_id) where forum_id = :forum_id