<?xml version="1.0"?> <queryset> <fullquery name="uncategorized_count"> <querytext> select count(*) as uncategorized_count from bboard_forum_message_map msg where forum_id = :forum_id and not exists (select 1 from bboard_category_message_map cat where msg.message_id = cat.message_id) </querytext> </fullquery> <fullquery name="uncategorized_approved_count"> <querytext> select count(*) as uncategorized_count from bboard_forum_message_map msg where forum_id = :forum_id and status = 'approved' and not exists (select 1 from bboard_category_message_map cat where msg.message_id = cat.message_id) </querytext> </fullquery> <fullquery name="messages_select_unmoderated"> <querytext> select message_id, title, num_replies, first_names||' '||last_name as full_name from bboard_messages_all, persons where forum_id = :forum_id and person_id = sender and reply_to is null and status = 'unmoderated' </querytext> </fullquery> <fullquery name="rejected_messages_select"> <querytext> select message_id, title, num_replies, first_names||' '||last_name as full_name from bboard_messages_all, persons where forum_id = :forum_id and person_id = sender and reply_to is null and status = 'rejected' </querytext> </fullquery> </queryset>