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