select count(*) as num_regions from portal_supported_regions where layout_id = :layout_id select element_id, pem.pretty_name as name, pem.sort_key, state, pem.page_id as page_id from portal_element_map pem, portal_pages pp where pp.portal_id = :portal_id and pem.page_id = pp.page_id and pp.page_id = :page_id and region = :region and state != 'hidden' order by sort_key select count(*) as all_count from portal_element_map pem, portal_pages pcp where pcp.portal_id = :portal_id and pem.page_id = pcp.page_id and state != 'hidden' and region not like 'i%' select element_id, name from portal_element_map pem, portal_pages pp where pp.portal_id = :portal_id and pp.page_id = pem.page_id and pem.state = 'hidden' order by name