postgresql7.2.1
select forums_messages.message_id,
forums_messages.subject,
to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
forums_forums.forum_id,
forums_forums.package_id,
forums_forums.name as forum_name,
(select site_node__url(node_id)
from site_nodes
where object_id = forums_forums.package_id) as url
from forums_messages,
forums_forums
where forums_messages.user_id = :user_id
and forums_messages.forum_id = forums_forums.forum_id
order by forums_messages.posting_date desc
select forums_messages.message_id,
forums_messages.subject,
to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
forums_forums.forum_id,
forums_forums.package_id,
forums_forums.name as forum_name,
(select site_node__url(node_id)
from site_nodes
where object_id = forums_forums.package_id) as url
from forums_messages,
forums_forums
where forums_messages.user_id = :user_id
and forums_messages.forum_id = forums_forums.forum_id
order by forum_name,
forums_messages.posting_date desc