select count(*)
from portal_layout_regions
where layout_id = :layout_id
select region
from portal_layout_regions
where layout_id = :layout_id
order by region
select layout_id,
name as layout_name,
description as layout_description
from portal_layouts
select layout_id
from portal_layouts
where name = :name