oracle8.1.6
select forums_forums_enabled.*,
approved_thread_count as n_threads,
to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
$unread_or_new_query_clause
from forums_forums_enabled
where forums_forums_enabled.package_id = :package_id
and acs_permission.permission_p(forums_forums_enabled.forum_id, :user_id, 'read') = 't'
order by forums_forums_enabled.name