oracle8.1.6
select s.slide_title,
s.sort_key,
s.original_slide_id,
wp_slide.get_preamble(:slide_item_id) as preamble,
wp_slide.get_postamble(:slide_item_id) as postamble,
wp_slide.get_bullet_items(:slide_item_id) as bullet_items
from cr_wp_slides s, cr_items i
where i.item_id = :slide_item_id
and i.live_revision = s.slide_id