postgresql7.4
SELECT i.as_item_id, i.name, i.title, s.section_id as section_id, s.title as section_title, s.description as section_description
FROM as_sectionsx s INNER JOIN as_assessment_section_map asm USING (section_id)
INNER JOIN as_assessmentsx a USING (assessment_id)
INNER JOIN as_item_section_map ism ON s.section_id = ism.section_id
INNER JOIN as_itemsx i USING (as_item_id)
WHERE a.assessment_id = :assessment_id
ORDER BY s.section_id, ism.sort_order