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_f 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_f where as_item_display_id = :type_id select file_id from as_item_data where as_item_id=:item_id and session_id=:session_id and section_id=:section_id