Difference between revisions of "File:WP favors men.xls"
MyWikiBiz, Author Your Legacy — Sunday April 28, 2024
Jump to navigationJump to search (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...) |
m (break code into lines) |
||
| Line 6: | Line 6: | ||
SELECT | SELECT | ||
| − | + | ||
| + | page_title | ||
| + | |||
FROM page | FROM page | ||
| + | |||
JOIN categorylinks | JOIN categorylinks | ||
| + | |||
ON cl_from = page_id | ON cl_from = page_id | ||
| + | |||
WHERE cl_to = 'Living_people' | WHERE cl_to = 'Living_people' | ||
| + | |||
AND page_is_redirect = 0 | AND page_is_redirect = 0 | ||
| + | |||
AND page_namespace = 0 | AND page_namespace = 0 | ||
| + | |||
AND page_random > RAND() | AND page_random > RAND() | ||
| + | |||
ORDER BY page_random | ORDER BY page_random | ||
| + | |||
LIMIT 500; | LIMIT 500; | ||
Latest revision as of 14:53, 6 November 2014
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;
File history
Click on a date/time to view the file as it appeared at that time.
| Date/Time | Dimensions | User | Comment | |
|---|---|---|---|---|
| current | 14:52, 6 November 2014 | (45 KB) | MyWikiBiz (talk | contribs) | 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... |
You cannot overwrite this file.
File usage
There are no pages that use this file.
