select page_id as prev_page_id
from layout_pages
where pageset_id = :pageset_id
and sort_key = (select sort_key - 1
from layout_pages
where page_id = :page_id)
select page_id as next_page_id
from layout_pages
where pageset_id = :pageset_id
and sort_key = (select sort_key + 1
from layout_pages
where page_id = :page_id)
select count(*) as element_count
from layout_elements
where page_id = :page_id
and page_column = :page_column
and state <> 'hidden'
select element_id, name, title, sort_key, state
from layout_elements
where page_id = :page_id
and page_column = :page_column
and state <> 'hidden'
order by sort_key