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