Bureaucrats, Check users, Interface administrators, Administrators (Semantic MediaWiki), Administrators, vuser
9,362
edits
Changes
A randomized data set generated by Wikimedia Toolserver expert MZMcBride, we have the facts about a lack of gender equality in the hundreds of thousands of biographies of living people published on Wikipedia: Approximately 81% of the Wikipedia article...
A randomized data set generated by Wikimedia Toolserver expert MZMcBride, we have the facts about a lack of gender equality in the hundreds of thousands of biographies of living people published on Wikipedia:
Approximately 81% of the Wikipedia articles about living people are about males, as of January 2011.
Query code:
SELECT
page_title
FROM page
JOIN categorylinks
ON cl_from = page_id
WHERE cl_to = 'Living_people'
AND page_is_redirect = 0
AND page_namespace = 0
AND page_random > RAND()
ORDER BY page_random
LIMIT 500;
Approximately 81% of the Wikipedia articles about living people are about males, as of January 2011.
Query code:
SELECT
page_title
FROM page
JOIN categorylinks
ON cl_from = page_id
WHERE cl_to = 'Living_people'
AND page_is_redirect = 0
AND page_namespace = 0
AND page_random > RAND()
ORDER BY page_random
LIMIT 500;