postgresql7.1 select fma.message_id from forums_messages fm, forums_messages_approved fma where fm.message_id = :root_message_id and fma.forum_id = :forum_id and fma.tree_sortkey between fm.tree_sortkey and tree_right(fm.tree_sortkey) order by fma.message_id select message_id, 0 as n_attachments, subject, content, format, person__name(user_id) as user_name, to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, tree_level(tree_sortkey) as tree_level, state, user_id, parent_id from $table_name where forum_id = :forum_id and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey) order by $order_by select message_id, (select count(*) from attachments where object_id = message_id) as n_attachments, subject, content, format, person__name(user_id) as user_name, to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, tree_level(tree_sortkey) as tree_level, state, user_id, parent_id from $table_name where forum_id = :forum_id and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey) order by $order_by