Stratified sample of 400 articles from glwiki

SQL

USE glwiki_p;
(SELECT "<1k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len < 1000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "1-4k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 1001 AND 4000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "4-10k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 4001 AND 10000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "10-20k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 10001 AND 20000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "20-30k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 20001 AND 30000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "30-50k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 30001 AND 50000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "50-100k" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len BETWEEN 50001 AND 100000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
UNION ALL
(SELECT "100k-" AS length_group, page_title, page_latest AS rev_id FROM page WHERE page_len > 100000 AND page_namespace = 0 AND NOT page_is_redirect ORDER BY RAND() LIMIT 50)
SQL

Checking query status...
