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 bm.bookmark_id, bm.url_id, bm.local_title, bm.folder_p, bm.parent_id, bm.owner_id, bm.tree_sortkey from bm_bookmarks bm, bm_bookmarks bm2 where bm2.bookmark_id = :root_folder_id and bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.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 b.tree_sortkey delete from bm_in_closed_p where creation_date < (current_timestamp - interval '1 day')