postgresql7.1
select forums_forums_enabled.*,
(select count(*)
from forums_messages
where forums_messages.forum_id = forums_forums_enabled.forum_id
and 1 = tree__tree_level(forums_messages.tree_sortkey)) as n_threads,
to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified
from forums_forums_enabled,
acs_objects
where forums_forums_enabled.package_id = :package_id
and (
forums_forums_enabled.posting_policy = 'open'
or forums_forums_enabled.posting_policy = 'moderated'
or 't' = acs_permission__permission_p(:user_id, forums_forums_enabled.forum_id, 'forum_read')
)
and forums_forums_enabled.forum_id = acs_objects.object_id
order by forums_forums_enabled.name