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 display_type from as_item_types_map where item_type = :item_type select cr.title || ' (' || cr.content_length || ' bytes)' as content_name, cr.revision_id as content_rev_id, cr.title as content_filename from cr_revisions cr, as_item_rels r where r.item_rev_id = :as_item_id and r.target_rev_id = cr.revision_id and r.rel_type = 'as_item_content_rel' select r.title, r.description, i.subtext, i.field_name, i.field_code, i.required_p, i.feedback_right, i.feedback_wrong, i.max_time_to_complete, i.data_type, i.points, i.validate_block, r.content as question_text, r.mime_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_display_rel' and o.object_id = r.target_rev_id insert into as_item_rels (target_rev_id, item_rev_id, rel_type) values (:content_rev_id, :new_item_id, 'as_item_content_rel') update as_item_rels set target_rev_id = :content_rev_id where item_rev_id = :new_item_id and rel_type = 'as_item_content_rel' delete from as_item_rels where item_rev_id = :new_item_id and rel_type = 'as_item_content_rel' update as_assessment_section_map set section_id = :new_section_id where assessment_id = :new_assessment_rev_id and section_id = :section_id update as_item_section_map set as_item_id = :new_item_id, points = :points, required_p = :required_p where section_id = :new_section_id and as_item_id = :as_item_id update cr_revisions set title = :title where revision_id = :new_choice_id update as_item_choices set correct_answer_p = :correct_answer_p, sort_order = :count where choice_id = :new_choice_id update as_item_rels set target_rev_id = :new_item_type_id where item_rev_id = :new_item_id and rel_type = 'as_item_type_rel' select sort_order from as_item_choices where choice_id=:n select substring(title from 1 for 50) as title, revision_id from (select r.title, r.revision_id, case when m.target_rev_id is not null then 0 else 1 end as sort_key from cr_items i, cr_revisions r left join (select r1.target_rev_id from as_item_section_map m1, as_item_rels r1, as_assessment_section_map m2, cr_items i2, cr_items i3, cr_items i4 where m1.as_item_id = r1.item_rev_id and r1.rel_type = 'as_item_type_rel' and m1.section_id = m2.section_id and m2.assessment_id = i2.latest_revision and m1.as_item_id = i3.latest_revision and m1.section_id = i4.latest_revision and i2.item_id = :assessment_id) m on m.target_rev_id = r.revision_id where i.parent_id = :folder_id and r.revision_id = i.latest_revision and i.content_type like 'as_item_type_mc') q order by sort_key select distinct title, revision_id from (select substr(title,1,50) as title, revision_id from cr_items i, cr_revisions r where i.parent_id = :folder_id and r.title is not NULL and r.revision_id = i.latest_revision and i.content_type = 'as_item_type_mc') c