select theme_id, name || ' - ' || description as name from portal_themes order by name select element_id, pe.name from portal_elements pe, portal_pages pp where pp.portal_id = :portal_id and pp.page_id = pe.page_id and pe.state = 'hidden' order by pe.name select page_id from portal_pages where portal_id = :portal_id order by sort_key