select i.choice_id, cr.title, i.content_value
from as_item_choices i, cr_revisions cr
where i.mc_id = :mc_id
and cr.revision_id = i.choice_id
order by i.sort_order
select i.choice_id, cr.title
from as_item_choices i, cr_revisions cr
where i.mc_id = :mc_id
and cr.revision_id = i.choice_id
order by i.sort_order
select cr.title, i.required_p
from as_items i, cr_revisions cr
where i.as_item_id = :item_id
and cr.revision_id = i.as_item_id