select item_id from cr_revisions where revision_id = :as_item_display_id select i.html_display_options, i.choice_orientation, i.choice_label_orientation, i.sort_order_type, i.item_answer_alignment from cr_revisions cr, as_item_display_rb i where cr.revision_id = :type_id and i.as_item_display_id = cr.revision_id