https://bugzilla.wikimedia.org/show_bug.cgi?id=34590
--- Comment #9 from Nicolas Brouard <[email protected]> 2012-02-27 12:28:25 UTC --- In order to know how frequent multiple usernames have the same e-mail, I would like to get the result of the mysql command on some of your wikis including Wikipedia: select email_freq, COUNT(email_freq) FROM (select user_email, COUNT(user_email) as email_freq FROM prefix_user WHERE user_email <> "NULL" GROUP BY user_email ) AS DISTRIB GROUP BY email_freq; Here is the result on mine: +------------+-------------------+ | email_freq | COUNT(email_freq) | +------------+-------------------+ | 1 | 3047 | | 2 | 22 | | 3 | 1 | +------------+-------------------+ On the above example, 22 users have 2 usernames having the same e-mail. 1 have 3, and all the others have an e-mail link to a unique username. I suppressed the number of people having no e-mail authenticated (NULL). It won't be the same benefit of this patch to Wikipedia users, but I would be happy if you know who I can ask in order to get the results. I was guessing 90% but I am probably pessimistic... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
