select p.first_names ||' '|| p.last_name as sender_name, b.title,
b.mime_type as msg_mime_type, b.content
from bboard_messages_all b, persons p
where message_id = :message_id
and b.sender = p.person_id
select forum_id, short_name
from bboard_forums
where not forum_id = :forum_id
and exists (select 1 from all_object_party_privilege_map
where object_id = forum_id
and party_id = :user_id
and privilege = 'admin')