Duplicate email list

[penmai.com]

Hi we have few members having multiple account with single email id.

how can i get the member list and the email ids? could anyone help. Previously i saw one sql script but don't know where it is.

thank you

[Trevor Hannant]

To get a full list of usernames, user ids and email addresses in a single list, you'll need to get that from running a query against your database in something like phpMyAdmin. The following should get this for you:

SELECT userid, username, email FROM (PREFIX)user
ORDER BY email

If your tables have a prefix, change (PREFIX) to this - if not, remove that.

This will give you a list of your users ordered by email address which you can then use to easily see duplicates. You should also be able to export this to a CSV or other file if you wish to retain this.