Sample revisions of Controversial Topics

SQL

# https://en.wikipedia.org/wiki/Category:Wikipedia_objectionable_content
# https://www.mediawiki.org/wiki/Manual:Categorylinks_table
# took 497 seconds for 10M rev ids
SELECT revision.rev_id, revision.rev_comment_id, revision.rev_timestamp, 
    revision.rev_minor_edit, revision.rev_parent_id, revision.rev_len, page.* FROM revision
JOIN page on revision.rev_page = page.page_id
JOIN categorylinks ON categorylinks.cl_from = page.page_id
WHERE categorylinks.cl_to = "Wikipedia_controversial_topics"
#AND rev_id < 30000000; # took 1446 seconds (24 mins)
#AND rev_id >= 30000000 AND rev_id < 60000000; # took 2437 seconds
#AND rev_id >= 60000000 AND rev_id < 90000000; # took 2242 seconds
#AND rev_id >= 90000000 AND rev_id < 120000000; # took 1737 seconds
#AND rev_id >= 120000000 AND rev_id < 150000000; # took 1588 seconds
#AND rev_id >= 150000000 AND rev_id < 180000000; # took 1443 seconds
#AND rev_id >= 180000000 AND rev_id < 210000000; # took 1626 seconds
AND rev_id >= 210000000 AND rev_id < 240000000; # took  seconds
#AND rev_id >= 240000000 AND rev_id < 270000000; # took  seconds
#AND rev_id >= 270000000 AND rev_id < 300000000; # took  seconds
SQL

Checking query status...
