oracle8.1.6 select item_id, content_item.get_best_revision(item_id) as revision_id, content_revision.get_number(news_id) as revision_no, publish_title, html_p, publish_date, archive_date, creation_user, item_creator, package_id, status from news_items_live_or_submitted where package_id = :package_id $view_option order by item_id desc