select session_id, creation_datetime, completed_datetime from as_sessions, cr_revisions where item_id=:assessment_id and assessment_id=revision_id and subject_id=:subject_id select count(*) from as_sessions, cr_revisions where item_id=:assessment_id and assessment_id=revision_id and subject_id=:subject_id