select r.title, r.description, i.subtext, i.field_code, i.definition, i.required_p, i.feedback_right, i.feedback_wrong, i.max_time_to_complete, i.data_type from cr_revisions r, as_items i where r.revision_id = i.as_item_id and i.as_item_id = :as_item_id select o.object_type from acs_objects o, as_item_rels r where r.item_rev_id = :as_item_id and r.rel_type = 'as_item_type_rel' and o.object_id = r.target_rev_id select o.object_type from acs_objects o, as_item_rels r where r.item_rev_id = :as_item_id and r.rel_type = 'as_item_display_rel' and o.object_id = r.target_rev_id