are the usernames exactly the same? No domains or anything to strip out?
if you remove the where command at the end and maybe sort by username do you see any you would consider duplicates? Or in general do you see data you'd expect - a username, a count and field for types, probably containing one or two entries?
... View more