select item_id
from cr_revisions
where revision_id = :as_item_type_id
select cr.title, i.increasing_p, i.allow_negative_p, i.num_correct_answers,
i.num_answers
from cr_revisions cr, as_item_type_mc i
where cr.revision_id = :type_id
and i.as_item_type_id = cr.revision_id
select cr.item_id as type_item_id, cr.title, i.increasing_p,
i.allow_negative_p, i.num_correct_answers, i.num_answers
from cr_revisions cr, as_item_type_mc i
where cr.revision_id = :as_item_type_id
and i.as_item_type_id = cr.revision_id
select choice_id
from as_item_choices
where mc_id = :type_id
select choice_id
from as_item_choices
where mc_id = :type_id
select num_correct_answers, num_answers
from as_item_type_mc
where as_item_type_id = :type_id
select c.choice_id, r.title, c.correct_answer_p, c.selected_p
from as_item_choices c, cr_revisions r
where c.mc_id = :type_id
and r.revision_id = c.choice_id
order by c.sort_order
select increasing_p, allow_negative_p
from as_item_type_mc
where as_item_type_id = :type_id
select choice_id, correct_answer_p, percent_score
from as_item_choices
where mc_id = :type_id