Sample revisions of Controversial Topics

SQL

# https://en.wikipedia.org/wiki/Category:Wikipedia_objectionable_content
# https://www.mediawiki.org/wiki/Manual:Categorylinks_table

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 < 10000000; # took  seconds
#AND rev_id >= 200000000 AND rev_id < 400000000; # took  seconds
#AND rev_id >= 400000000 AND rev_id < 600000000; # took  seconds
#AND rev_id >= 600000000 AND rev_id < 800000000; # took  seconds
#AND rev_id >= 800000000; # took  seconds
SQL

Checking query status...
