oracle8.1.6 select content, mime_type from cr_revisions where revision_id = content_item.get_live_revision(:content_item_id) select header_subject as title, to_char(send_date, 'Month DD, YYYY HH:MI:SS') as send_date, content_item_id from spam_messages_all where spam_id = :spam_id select cr.content as plain_text from acs_mail_multipart_parts mpp, cr_items ci, cr_revisions cr where mpp.content_item_id=ci.item_id and ci.live_revision=cr.revision_id and multipart_id=:content_item_id and cr.mime_type='text/plain' select cr.content as html_text from acs_mail_multipart_parts mpp, cr_items ci, cr_revisions cr where mpp.content_item_id=ci.item_id and ci.live_revision=cr.revision_id and multipart_id=:content_item_id and cr.mime_type='text/html'