select item_id, package_id, publish_title, publish_date from news_items_approved where publish_date < sysdate and (archive_date is null or archive_date > sysdate) and package_id = :instance_id order by publish_date desc, item_id desc select count(*) from news_items_approved where publish_date < sysdate and (archive_date is null or archive_date > sysdate) and package_id = :instance_id