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