select layout_id, description from portal_layouts order by layout_id select count(*) as region_count from portal_layout_regions where layout_id = :page_layout_id select region from portal_layout_regions where layout_id = :page_layout_id order by region