select c.title, t.increasing_p, t.allow_negative_p, t.num_correct_answers, t.num_answers, max(t.as_item_type_id) as as_item_type_id from as_item_type_mc t, cr_revisions c, as_item_rels r where t.as_item_type_id = r.target_rev_id and r.item_rev_id = :as_item_id and r.rel_type = 'as_item_type_rel' and c.revision_id = t.as_item_type_id group by c.title, t.increasing_p, t.allow_negative_p, t.num_correct_answers, t.num_answers