postgresql7.1 select s.title, s.source_id, s.feed_url, s.link, s.description, s.updates, to_char(s.last_scanned, 'YYYY-MM-DD HH24:MI') as last_scanned, to_char(s.last_modified_stamp, 'YYYY-MM-DD HH24:MI') as last_modified from na_sources s join ( na_subscriptions su join na_aggregators a on (a.aggregator_id = su.aggregator_id)) on (s.source_id = su.source_id) where a.package_id = :package_id and a.aggregator_id = :aggregator_id [ad_decode source "" "" [template::list::orderby_clause -orderby -name sources]] select na_source__delete( :delete_id );