select s.section_id, cr.title, ci.name, s.instructions, s.feedback_text, asm.max_time_to_complete, asm.sort_order, asm.points, s.display_type_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where cr.revision_id = s.section_id and s.section_id = asm.section_id and cr.revision_id = ci.latest_revision and asm.assessment_id = :assessment_rev_id order by s.section_id, asm.sort_order -- select s.section_id, cr.title -- from as_sections s, cr_revisions cr, as_assessment_section_map asm -- where cr.revision_id = s.section_id -- and s.section_id = asm.section_id -- and asm.assessment_id = :assessment_rev_id -- order by asm.sort_order select max(asm.sort_order) from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id = :assessment_rev_id