mipmip · February 16, 2012 12:05
diff --git a/gistfile1.sql b/gistfile1.sql
 CREATE TEMPORARY TABLE keepids (
 SELECT MIN(uid) FROM tt_address
 GROUP BY (email)
 );

 DELETE FROM tt_address WHERE uid NOT IN (SELECT * FROM keepids);

 DROP TABLE keepids;
	CREATE TEMPORARY TABLE keepids (
	SELECT MIN(uid) FROM tt_address
	GROUP BY (email)
	);

	DELETE FROM tt_address WHERE uid NOT IN (SELECT * FROM keepids);

	DROP TABLE keepids;