select max(revision_id) from cr_revisions where item_id=:d_assessment