findduplicates.sql

USE acore_auth;

SELECT testOne.username, testTwo.username
FROM    account as testOne,
        account as testTwo
WHERE   
        testOne.username=testTwo.username
OR      testOne.last_ip=testTwo.last_ip
OR      testOne.last_ip=testTwo.last_attempt_ip
OR      testOne.last_attempt_ip=testTwo.last_ip
OR      testOne.email=testTwo.email
OR      testOne.sha_pass_hash = testTwo.sha_pass_hash
OR      testOne.username LIKE CONCAT('%', testTwo.username ,'%')
OR      testTwo.username LIEK CONCAT('%', testOne.username ,'%')
;