oracle8.1.6
select s.source_id,
s.link,
s.description,
s.title,
to_char(last_scanned, '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 s.source_id = i.source_id
and deleted_p = '0'
and package_id in ([join $list_of_package_ids ", "])
and rownum <= 10
order by creation_date desc