Sample revisions of Objectionable Content

SQL

# https://en.wikipedia.org/wiki/Category:Wikipedia_objectionable_content
# https://www.mediawiki.org/wiki/Manual:Categorylinks_table
# Count executed in 1297.57 seconds as of Tue Jun 25 2019, count: 276,607

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_objectionable_content"
AND rev_deleted = 0
#AND rev_id < 100000000; # took 852 seconds
#AND rev_id >= 100000000 AND rev_id < 300000000; # took 1558 seconds
AND rev_id >= 300000000 AND rev_id < 500000000; # took  seconds
SQL

Checking query status...
