select short_name as forum_name from bboard_forums where forum_id = :forum_id select email as sender_email from parties where party_id = :user_id select reply_to, title, sent_date, mime_type, content, first_names||' '||last_name as full_name from acs_messages_all m, persons p where message_id = :message_id and person_id = sender