postgresql7.1 select m.element_id, value as folder_id, p.page_id as current_page_id from portal_element_parameters ep, portal_element_map m, portal_pages p where ep.element_id = m.element_id and m.page_id = p.page_id and p.portal_id = :portal_id and ep.key = 'folder_id' and m.pretty_name = :fs_link limit 1 select org.org_id, org.org_title as org_title, org.hasmetadata, tree_level(cr.tree_sortkey) as indent from ims_cp_organizations org, cr_items cr where cr.item_id = ( select item_id from cr_revisions where revision_id = org.org_id) and man_id = :man_id order by org_id