Query to find duplicate members

[odonel]

Hello all,

what would a query look like to find duplicate members ? I need to list all members who signon, register, posts with more than 1 id. my forum is bomdared with dup members. I need to get rid of them... I did search and found no help....

any add-ons or a query will help

thanx

[Opserty]

Define "duplicate members" members with the same username? ip? email? or what?

How do you mean you are being bombarded? Are we talking spambots or importing members or?

[odonel]

what i meant was 1 user who registers many times with different names... sorry if i confused anyone...