select cr.item_id
from as_item_data d, cr_revisions cr
where cr.revision_id=d.item_data_id
and d.session_id=:session_id
select cr.item_id
from as_session_results s, cr_revisions cr , cr_revisions cr2
where cr.revision_id=s.result_id
and s.target_id=cr2.revision_id
and cr2.item_id=:item_id
select cr.item_id
from as_section_data d, cr_revisions cr
where cr.revision_id=d.section_data_id
and d.session_id=:session_id
select g.comment_id
from general_comments g
where object_id=:session_id