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, pp.page_id, pd.description from portal_element_map pem, portal_datasources pd, portal_pages pp where pp.portal_id = :portal_id and pp.page_id = :page_id and pem.page_id = pp.page_id and pem.datasource_id = pd.datasource_id and region = :region and state != 'hidden' order by sort_key select value as shadeable_p from portal_element_parameters where key = :key and element_id = :element_id select count(*) as all_count from portal_element_map pem, portal_pages pp where pp.portal_id = :portal_id and pp.page_id = :page_id and pp.page_id = pem.page_id and state != 'hidden' and region not like 'i%' select element_id, pem.pretty_name from portal_element_map pem, portal_pages pp where pp.portal_id = :portal_id and pp.page_id = :page_id and pp.page_id = pem.page_id and pem.state = 'hidden' order by name