select item_id from cr_revisions where revision_id = :as_item_type_id select cr.title, i.default_value, i.feedback_text from cr_revisions cr, as_item_type_oq i where cr.revision_id = :type_id and i.as_item_type_id = cr.revision_id select default_value as default from as_item_type_oq where as_item_type_id = :type_id