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