profaller

DELETE
FROM cities
WHERE id NOT IN (

  SELECT id
  FROM (
         SELECT t1.id

         FROM cities t1

           LEFT JOIN (
                       SELECT id
                       FROM cities
                       GROUP BY name
                     ) t2 ON t1.id = t2.id

         WHERE t2.id IS NOT NULL
       ) tmp
)