update na_sources set last_scanned = now(), title = :title, link = :link, description = :description where source_id = :source_id where last_scanned < (now() - '00:48:00'::time) select source_id, feed_url, last_modified from na_sources $time_limit order by last_scanned asc $limit_sql limit $limit select na_source__new ( :source_id, :feed_url, :link, :title, :description, :last_modified, '1', :package_id, :user_id, :creation_ip ) select na_item__new ( :source_id, :link, :guid, boolean :permalink_p, :title, :description, :content_encoded ); update na_sources set link = :link, title = :title, description = :description, updates = (updates + 1), last_scanned = now(), last_modified = now(), last_modified_stamp = now() where source_id = :source_id select na_item__new ( :source_id, :link, :guid, :original_guid, boolean :permalink_p, :title, :description, :content_encoded ); select na_source__delete( :source_id );