select title as section_title
from cr_revisions
where revision_id = :section_id
select i.as_item_id
from cr_items ci, cr_revisions cr, as_items i
where cr.revision_id = ci.latest_revision
and i.as_item_id = cr.revision_id
and i.as_item_id not in (select m.as_item_id
from as_item_section_map m
where m.section_id = :section_id)
$orderby_clause
select i.as_item_id, cr.title
from cr_items ci, cr_revisions cr, as_items i
where cr.revision_id = ci.latest_revision
and i.as_item_id = cr.revision_id
and i.as_item_id not in (select m.as_item_id
from as_item_section_map m
where m.section_id = :section_id)
$page_clause
$orderby_clause