select c.choice_id, r.title, c.correct_answer_p
from as_item_choices c, cr_revisions r
where r.revision_id = c.choice_id
and c.mc_id = :mc_id
order by c.sort_order
update as_item_choices
set feedback_text = :feedback_text,
selected_p = :selected_p,
percent_score = :percent_score,
fixed_position = :fixed_position,
text_value = :answer_value,
content_value = :content_rev_id
where choice_id = :choice_id