postgresql7.1 select site_node__url(node_id) as path from site_nodes where object_id in (select package_id from apm_packages where package_key = 'bookmarks') select b.bookmark_id, b.url_id, b.local_title, acs_objects.creation_date, b.parent_id, bm_urls.complete_url, b.folder_p from (select bookmark_id, url_id, local_title, folder_p, parent_id, owner_id from bm_bookmarks where tree_sortkey like ( select tree_sortkey || '%' from bm_bookmarks where bookmark_id = :root_folder_id ) order by tree_sortkey) b left join bm_urls using (url_id), acs_objects where owner_id = :user_id and acs_objects.object_id = b.bookmark_id order by tree_sortkey delete from bm_in_closed_p where creation_date < (current_timestamp - 1)