select r.title, c.data_type, c.numeric_value, c.text_value, c.boolean_value,
c.content_value, c.feedback_text, c.selected_p, c.correct_answer_p,
c.sort_order, c.percent_score, c.fixed_position, r.item_id as item_choice_id
from cr_revisions r, as_item_choices c
where r.revision_id = :choice_id
and c.choice_id = r.revision_id
select r.title, c.data_type, c.numeric_value, c.text_value, c.boolean_value,
c.content_value, c.feedback_text, c.selected_p, c.correct_answer_p,
c.sort_order, c.percent_score, c.fixed_position, r.item_id as choice_item_id
from cr_revisions r, as_item_choices c
where r.revision_id = :choice_id
and c.choice_id = r.revision_id