Error:

DELETE FROM t_23andme_addref       

WHERE id IN (  SELECT min(id)  FROM t_23andme_addref   GROUP BY rsid 

HAVING count(rsid) > 1)

ERROR 1064 (42000): You have an error in your SQL syntax;

DELETE tt  FROM t_23andme_addref tt,       (  SELECT min(id) AS id            FROM t_23andme_addref        GROUP BY rsid          HAVING count(rsid) > 1) AS b WHERE tt.id = b.id;