select title as assessment_title from cr_revisions where revision_id = :assessment_rev_id