postgresql7.1 select bookmark_id, complete_url, coalesce(local_title, url_title) as title, meta_keywords, meta_description from (select bookmark_id, url_id, local_title, folder_p, 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, bm_urls where owner_id = :browsing_user_id and folder_p = 'f' and b.url_id = bm_urls.url_id and b.bookmark_id <> :root_folder_id and ( upper(local_title) like :search_pattern or upper(url_title) like :search_pattern or upper(complete_url) like :search_pattern or upper(meta_keywords) like :search_pattern or upper(meta_description) like :search_pattern) order by title select distinct complete_url, bookmark_id, coalesce(local_title, url_title) as title, meta_keywords, meta_description, folder_p, acs_permission__permission_p(bookmark_id, :browsing_user_id, 'admin') as admin_p from ( select o2.bookmark_id, o2.url_id, o2.local_title, o2.folder_p, o2.owner_id from bm_bookmarks o1, bm_bookmarks o2 where o1.parent_id = :package_id and o2.tree_sortkey >= o1.tree_sortkey and o2.tree_sortkey like (o1.tree_sortkey || '%') order by o2.tree_sortkey ) b join bm_urls using (url_id) where owner_id <> :browsing_user_id and acs_permission__permission_p(bookmark_id, :browsing_user_id, 'read') = 't' and folder_p = 'f' and ( upper(local_title) like :search_pattern or upper(url_title) like :search_pattern or upper(complete_url) like :search_pattern or upper(meta_keywords) like :search_pattern or upper(meta_description) like :search_pattern ) order by title