postgresql7.4
SELECT i.as_item_id, i.name, i.title, i.feedback_right, i.feedback_wrong,
s.section_id, s.title as section_title, s.description as section_description
FROM as_assessmentsx a, as_sectionsx s, as_assessment_section_map asm, as_itemsx i,
as_item_section_map ism, as_sessionsx ss
WHERE a.assessment_id = asm.assessment_id
AND s.section_id = asm.section_id
AND i.as_item_id = ism.as_item_id
AND s.section_id = ism.section_id
AND a.assessment_id = ss.assessment_id
AND ss.session_id = :session_id
ORDER BY s.section_id, ism.sort_order
SELECT
as_item_choicesx.choice_id, as_item_choicesx.title AS choice_title, as_item_choicesx.correct_answer_p, as_item_choicesx.percent_score, as_item_choicesx.text_value, as_item_choicesx.content_value
FROM as_item_choicesx
WHERE
as_item_choicesx.mc_id=:mc_id
ORDER BY
as_item_choicesx.sort_order
SELECT as_item_datax.text_answer
FROM as_item_datax, as_sessionsx
WHERE as_sessionsx.session_id = as_item_datax.session_id AND as_sessionsx.session_id = :session_id AND as_item_datax.choice_id_answer IS NULL AND as_item_datax.as_item_id = :items_as_item_id