oracle8.1.6 select message_id, subject from forums_messages where forum_id = :forum_id and tree_sortkey in (select substr(tree_sortkey, 1, 6) from forums_messages_pending where forum_id = :forum_id) order by tree_sortkey