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
select 1+max(sort_key)
from cr_wp_slides s,
cr_items i,
cr_revisions r
where i.parent_id = :pres_item_id
and s.slide_id = i.live_revision