MyWikiBiz: break code into lines

2014-11-06T14:53:42Z

break code into lines

MyWikiBiz: 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...

2014-11-06T14:52:56Z

New page

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;

@@ Line 6: / Line 6: @@
 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:WP favors men.xls - Revision history

MyWikiBiz: break code into lines

MyWikiBiz: 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...