Changes

MyWikiBiz, Author Your Legacy — Monday December 02, 2024
Jump to navigationJump to search
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;

Navigation menu