oracle8.1.6 select s.slide_title, s.sort_key, wp_slide.get_preamble_revision(:slide_revision_id) as preamble, wp_slide.get_postamble_revision(:slide_revision_id) as postamble, wp_slide.get_bullet_items_revision(:slide_revision_id) as bullet_items, ao.creation_date as modified_date from cr_wp_slides s, cr_items i, acs_objects ao where i.item_id = :slide_item_id and s.slide_id = :slide_revision_id and ao.object_id = s.slide_id select i.live_revision as attach_id, a.display, i.name as file_name from cr_items i, cr_wp_image_attachments a where i.parent_id = :slide_item_id and i.content_type in ('cr_wp_image_attachment', 'cr_wp_file_attachment') and i.live_revision = a.attach_id(+)