postgresql7.1
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