Open main menu
Home
Random
Log in
Settings
About MyWikiBiz
Disclaimers
MyWikiBiz
Search
Changes
← Older edit
File:WP favors men.xls
(view source)
Revision as of 14:53, 6 November 2014
8 bytes added
,
14:53, 6 November 2014
m
break code into lines
Line 6:
Line 6:
SELECT
SELECT
−
page_title
+
+
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;
MyWikiBiz
Bureaucrats
,
Check users
,
Interface administrators
,
Administrators (Semantic MediaWiki)
,
Administrators
, vuser
9,362
edits