select p.pres_title, p.page_signature, p.copyright_notice, p.public_p, p.show_modified_p from cr_wp_presentations p, cr_items i where i.item_id = :pres_item_id and p.presentation_id = :pres_revision_id select content as audience from cr_revisions r, cr_wp_presentations_aud pa where pa.presentation_id = :pres_revision_id and r.revision_id = pa.id select content as background from cr_revisions r, cr_wp_presentations_back pb where pb.presentation_id = :pres_revision_id and r.revision_id = pb.id