postgresql7.1 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, publish_date, content_revision__get_number(revision_id) as revision_number from cr_revisions r where r.item_id = :item_id order by revision_number desc