update cr_revisions set title=:title where revision_id=(select live_revision from cr_items where item_id=:file_id)