select title from cr_revisions where revision_id = :serial_id update cr_items set latest_revision = null where latest_revision = :serial_id