oracle8.1.6
select r.title, c.choice_id, r2.revision_id as content_rev_id,
r2.title as content_filename, i.content_type
from as_session_choices sc, cr_revisions r, as_item_choices c,
cr_revisions r2, cr_items i
where r2.revision_id = c.content_value (+)
and i.item_id = r2.item_id (+)
and sc.session_id = :session_id
and sc.section_id = :section_id
and sc.as_item_id = :as_item_id
and r.revision_id = sc.choice_id
and c.choice_id = sc.choice_id
order by sc.sort_order
select r.title, c.choice_id, c.correct_answer_p, c.feedback_text,
r2.revision_id as content_rev_id, r2.title as content_filename,
i.content_type
from as_session_choices sc, cr_revisions r, as_item_choices c,
cr_revisions r2, cr_items i
where r2.revision_id = c.content_value (+)
and i.item_id = r2.item_id (+)
and sc.session_id = :session_id
and sc.section_id = :section_id
and sc.as_item_id = :as_item_id
and r.revision_id = sc.choice_id
and c.choice_id = sc.choice_id
order by sc.sort_order
select c.choice_id, r.title, c.correct_answer_p, c.selected_p, c.fixed_position,
r2.revision_id as content_rev_id, r2.title as content_filename,
i.content_type
from cr_revisions r, as_item_choices c, cr_revisions r2, cr_items i
where r2.revision_id = c.content_value (+)
and i.item_id = r2.item_id (+)
and c.mc_id = :type_id
and r.revision_id = c.choice_id
order by c.sort_order