postgresql7.1
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