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