Удаление дубликатов по определённым полям MySQL

DELETE FROM cities
WHERE id NOT IN (SELECT *
FROM (SELECT MIN(n.id)
FROM cities n
GROUP BY n.regionid, n.okato) x)