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 1597 seconds
#AND rev_id >= 240000000 AND rev_id < 270000000; # took 1610 seconds
#AND rev_id >= 270000000 AND rev_id < 300000000; # took 1153 seconds
#AND rev_id >= 300000000 AND rev_id < 330000000; # took 1276 seconds
#AND rev_id >= 330000000 AND rev_id < 360000000; # took 1018 seconds
#AND rev_id >= 360000000 AND rev_id < 390000000; # took 1165 seconds
#AND rev_id >= 390000000 AND rev_id < 420000000; # took 560 seconds
#AND rev_id >= 390000000 AND rev_id < 450000000; # took 919 seconds
#AND rev_id >= 450000000 AND rev_id < 500000000; # took 807 seconds
#AND rev_id >= 500000000 AND rev_id < 550000000; # took 707 seconds
AND rev_id >= 550000000 AND rev_id < 650000000; # took  seconds
#AND rev_id >= 600000000 AND rev_id < 650000000; # took  seconds
SQL

Checking query status...
