oracle8.1.6 select s.source_id, s.link, s.description, s.title, to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS') as last_scanned, to_char(creation_date, 'YYYY-MM-DD HH24') as sort_date, feed_url, item_id, i.title as item_title, i.link as item_link, i.description as item_description from na_sources s, na_items i where owner_id = :user_id AND deleted_p = '0' and s.source_id = i.source_id and rownum <= $limit order by creation_date desc