select item_id
from cr_revisions
where revision_id = :as_item_type_id
select cr.title, i.increasing_p, i.allow_negative_p
from cr_revisions cr, as_item_type_fu i
where cr.revision_id = :type_id
and i.as_item_type_id = cr.revision_id
select d.session_id, d.text_answer
from as_item_data d, as_session_item_map m, cr_revisions ri, cr_revisions rs
where d.session_id in ([join $sessions ,])
and d.as_item_id = ri.revision_id
and ri.item_id = :as_item_item_id
and d.section_id = rs.revision_id
and rs.item_id = :section_item_id
and m.session_id = d.session_id
and m.item_data_id = d.item_data_id
update cr_revisions
set content=:content_file, mime_type =:mime_type,content_length=:tmp_size
where revision_id = :file_revision_id
update as_item_data
set file_id = :file_revision_id
where item_data_id=:as_item_data_id