DELETE FROM Person WHERE id NOT IN (SELECT id FROM (SELECT * FROM (SELECT * FROM person ORDER BY id ASC) AS kek GROUP BY email) AS top)