select s.section_id
from cr_items ci, cr_revisions cr, as_sections s
where cr.revision_id = ci.latest_revision
and s.section_id = cr.revision_id
and s.section_id not in (select m.section_id
from as_assessment_section_map m
where m.assessment_id = :assessment_rev_id)
$orderby_clause
select s.section_id, cr.title
from cr_items ci, cr_revisions cr, as_sections s
where cr.revision_id = ci.latest_revision
and s.section_id = cr.revision_id
and s.section_id not in (select m.section_id
from as_assessment_section_map m
where m.assessment_id = :assessment_rev_id)
$page_clause
$orderby_clause