postgresql7.1 select url_id, complete_url, coalesce(url_title, complete_url) as url_title from bm_urls where exists ( select 1 from ( select bookmark_id, url_id from bm_bookmarks where tree_sortkey like ( select tree_sortkey || '%' from bm_bookmarks where parent_id = :root_folder_id ) order by tree_sortkey ) bm where bm.url_id = bm_urls.url_id and acs_permission__permission_p(bm.bookmark_id, :browsing_user_id, 'delete')= 't' ) now() update bm_urls set last_checked_date = current_timestamp, url_title= :title, meta_description= :description, meta_keywords= :keywords $last_live_clause where url_id = :url_id