Ver originalSELECT CONCAT(dni) listaDNI, ip, count(distinct dni) total FROM tabla GROUP BY ip HAVING total >1