postgresql7.1 select message_id, subject from forums_messages where forum_id = :forum_id and tree_sortkey in (select tree_ancestor_key(tree_sortkey, 1) from forums_messages_pending where forum_id = :forum_id) order by tree_sortkey