oracle8.1.6 select item_id, revision_id, publication_name, publication_link, publication_date, publication_date_desc, article_title, article_link, article_pages, article_abstract, html_p, creation_date, status, item_creator, creation_ip, case when status = 'unapproved'then 0 else 1 end as approved_p, template_id, template_adp, null as template_value, case when content_revision.is_live(revision_id) = 't' then 1 else 0 end as is_live_p from press_item_revisions where item_id = :item_id and package_id = :package_id order by revision_id desc