postgresql7.1 select s.slide_title, s.sort_key, s.original_slide_id from cr_wp_slides s, cr_items i where i.item_id = :slide_item_id and i.live_revision = s.slide_id select content as preamble from cr_revisions, cr_items where cr_items.content_type = 'cr_wp_slide_preamble' and cr_items.parent_id = :slide_item_id and cr_revisions.revision_id = cr_items.live_revision select content as postamble from cr_revisions, cr_items where cr_items.content_type = 'cr_wp_slide_postamble' and cr_items.parent_id = :slide_item_id and cr_revisions.revision_id = cr_items.live_revision select content as bullet_items from cr_revisions, cr_items where cr_items.content_type = 'cr_wp_slide_bullet_items' and cr_items.parent_id = :slide_item_id and cr_revisions.revision_id = cr_items.live_revision;