select s.section_id, cr.title, cr.description, s.instructions, m.max_time_to_complete, s.display_type_id, s.num_items from cr_revisions cr, as_sections s, as_assessment_section_map m where cr.revision_id = s.section_id and s.section_id = :section_id and m.section_id = s.section_id and m.assessment_id = :assessment_rev_id select num_items, adp_chunk, branched_p, back_button_p, submit_answer_p, sort_order_type from as_section_display_types where display_type_id = :display_type_id select o.object_type as item_type, r.target_rev_id as item_type_id, m.points from acs_objects o, as_item_rels r, as_item_section_map m where r.item_rev_id = :response_item_id and r.rel_type = 'as_item_type_rel' and o.object_id = r.target_rev_id and m.as_item_id = r.item_rev_id and m.section_id = :section_id