select name, description
from layout_themes
order by name
select le.element_id, le.title
from layout_elements le, layout_pages lp
where lp.pageset_id = :pageset_id
and lp.page_id = le.page_id
and le.state = 'hidden'
order by le.name
select page_id
from layout_pages
where pageset_id = :pageset_id
order by sort_key