postgresql7.1 select message_id, subject, user_id, posting_date, state, tree_level(tree_sortkey) as tree_level from forums_messages where message_id in (select message_id from forums_messages_pending where forum_id = :forum_id) or tree_sortkey in (select tree_ancestor_key(tree_sortkey, 1) from forums_messages_pending where forum_id = :forum_id) order by tree_sortkey