oracle8.1.6 select content_item.get_content_type( :item_id ) from dual select item_id, name, locale, live_revision, publish_status, content_item.is_publishable(item_id) as is_publishable from cr_items where item_id = :item_id select revision_id, trim(title) as title, trim(description) as description, content_revision.get_number(revision_id) as revision_number from cr_revisions r where r.item_id = $item_id order by revision_number desc