oracle SELECT r.* FROM (SELECT item_id, publish_title AS title, '' AS lead, publish_date FROM news_items_approved WHERE package_id = :package_id $max_age_filter AND (archive_date IS NULL OR archive_date > sysdate) ORDER BY publish_date DESC, item_id DESC ) r WHERE rownum <= $n AND sysdate - to_timestamp(publish_date,'YYYY-MM-DD') < interval '$max_age' day