postgresql7.1
select message_id,
subject,
content,
person__name(user_id) as user_name,
to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
tree_level(tree_sortkey) as tree_level,
state,
user_id
from forums_messages_approved
where forum_id = :forum_id
and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
order by tree_sortkey
select message_id,
subject,
content,
person__name(user_id) as user_name,
to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
tree_level(tree_sortkey) as tree_level,
state,
user_id
from forums_messages_approved
where forum_id = :forum_id
and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
order by posting_date, tree_sortkey
select message_id,
subject,
content,
person__name(user_id) as user_name,
to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
tree_level(tree_sortkey) as tree_level,
state,
user_id
from forums_messages
where forum_id = :forum_id
and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
order by tree_sortkey
select message_id,
subject,
content,
person__name(user_id) as user_name,
to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
tree_level(tree_sortkey) as tree_level,
state,
user_id
from forums_messages
where forum_id = :forum_id
and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
order by posting_date, tree_sortkey