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=users&ususers=KTC&usprop=gender https://en.wikipedia.org/w/api.php?format=json&action=query&list=users&ususers=Fluffernutter&usprop=gender and others. KTC -- Katie Chan Any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent the view of any organisation the author is associated with or employed by. Experience is a good school but the fees are high. - Heinrich Heine --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com _______________________________________________ Gendergap mailing list Gendergap@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/gendergap
