select item_id from cr_revisions where revision_id = :as_item_display_id select i.html_display_options, i.abs_size, i.item_answer_alignment from cr_revisions cr, as_item_display_tb i where cr.revision_id = :type_id and i.as_item_display_id = cr.revision_id select html_display_options, abs_size, item_answer_alignment from as_item_display_tb where as_item_display_id = :type_id