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 ( forums_forums_enabled.posting_policy = 'open' or forums_forums_enabled.posting_policy = 'moderated' or 't' = acs_permission__permission_p(forums_forums_enabled.forum_id, :user_id,'forum_read') ) order by forums_forums_enabled.name approved_thread_count-coalesce((SELECT forums_reading_info_user.threads_read FROM forums_reading_info_user WHERE forums_reading_info_user.forum_id=forums_forums_enabled.forum_id AND forums_reading_info_user.user_id=:user_id), 0) as count_unread