Stratified sample of fawiki pages by length (600)

SQL

USE fawiki_p;
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 500 AND 5000 
ORDER BY RAND() LIMIT 125)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 5001 AND 10000
ORDER BY RAND() LIMIT 125)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 10001 AND 50000
ORDER BY RAND() LIMIT 125)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 50001 AND 100000
ORDER BY RAND() LIMIT 125)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 100001 AND 200000
ORDER BY RAND() LIMIT 32)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len BETWEEN 100001 AND 300000
ORDER BY RAND() LIMIT 32)
UNION ALL
(SELECT page_id, page_latest AS rev_id, page_len FROM page 
WHERE page_namespace = 0 AND NOT page_is_redirect AND page_len > 300000
ORDER BY RAND() LIMIT 61)
SQL

Checking query status...
