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
select 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
select r.title, r.item_id
from as_item_choices c, cr_revisions r
where r.revision_id = c.choice_id
and c.mc_id = :as_item_type_id
order by c.sort_order
select title
from cr_revisions
where revision_id = :as_item_id
select * from as_inter_item_checks where inter_item_check_id=:inter_item_check_id
update as_inter_item_checks set name=:name,section_id_from=:section_id_from,action_p=:action_p,postcheck_p=:postcheck_p,check_sql=:check_sql where inter_item_check_id=:inter_item_check_id
select check_sql from as_inter_item_checks where inter_item_check_id = :inter_item_check_id
select item_id from cr_revisions where revision_id=:section_id