postgresql 7.1
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, (select site_node__url(site_nodes.node_id) from site_nodes where site_nodes.object_id = package_id) as url, feed_url, item_id, i.title as item_title, i.link as item_link, i.description as item_description from na_sources s left outer join na_items i on (s.source_id = i.source_id) where deleted_p = '0' and package_id in ([join $list_of_package_ids ", "]) order by creation_date desc limit 10