On 09/12/2014 13:45, Fæ wrote:
The statistic comes from querying the English Wikipedia database. This includes a table of user preferences which itself is where the on-wiki preferences stores information like preferred gender.
Here's the SQL for anyone interested (it includes other redundant stuff, I was re-using something I already had to hand): SELECT user_name, user_editcount, LEFT(user_registration,4) AS reg, GROUP_CONCAT(DISTINCT ug_group SEPARATOR ' ') AS grps, GROUP_CONCAT(DISTINCT CONCAT(up_property,':',up_value)) AS prop FROM user u LEFT JOIN user_properties ON up_user=u.user_id LEFT JOIN user_groups ON u.user_id=ug_user WHERE user_name="''' +u +'''" AND up_property="gender" GROUP BY user_name ORDER BY user_editcount DESC;
(Where "u" is a variable iterating over the listed voters.)
As others are pointing out, the statistic of 1/590 is a fact
Err....
https://en.wikipedia.org/w/api.php?format=json&action=query&list=use... https://en.wikipedia.org/w/api.php?format=json&action=query&list=use...
and others.
KTC