select s.sort_key, s.slide_title, i.item_id as slide_item_id from cr_wp_slides s, cr_items i where i.parent_id = :pres_item_id and i.live_revision = s.slide_id order by s.sort_key select pres_title from cr_wp_presentations p, cr_items i where i.item_id = :pres_item_id and i.live_revision = p.presentation_id