Mysql mükerrer kayıtları silme. Delete duplicate

DELETE t1 FROM contacts t1 INNER JOIN contacts t2 WHERE t1.id < t2.id AND t1.email = t2.email;