Sample random revisions from big namespaces

SQL

# http://jan.kneschke.de/projects/mysql/order-by-rand/

### All non-deleted revisions in the article namespace
SELECT * FROM revision JOIN page on revision.rev_page = page.page_id WHERE rev_deleted = 0 AND page_namespace = 0 ORDER BY RAND() LIMIT 10000;

### All non-deleted revisions in the article-talk namespace
#SELECT * FROM revision JOIN page on revision.page_id = page.page_id WHERE rev_deleted = 0 AND page_namespace = 1 ORDER BY RAND() LIMIT 10000;

### All non-deleted revisions in the user namespace
#SELECT * FROM revision JOIN page on revision.page_id = page.page_id WHERE rev_deleted = 0 AND page_namespace = 2 ORDER BY RAND() LIMIT 10000;

### All non-deleted revisions in the user-talk namespace
#SELECT * FROM revision JOIN page on revision.page_id = page.page_id WHERE rev_deleted = 0 AND page_namespace = 3 ORDER BY RAND() LIMIT 10000;

### Revisions from pages whose talk pages cite a "Wikipedia is not censored" template
# https://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:Not_censored
# https://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:Censor
# https://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:Notcensored2
# https://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:Controversial
# https://en.wikipedia.org/wiki/Category:Wikipedia_objectionable_content
# https://en.wikipedia.org/wiki/Category:Wikipedia_controversial_topics

#SELECT * FROM revision ORDER BY RAND() LIMIT 1;
SQL

Checking query status...
