Sample revisions of Objectionable Content

SQL

# https://en.wikipedia.org/wiki/Category:Wikipedia_objectionable_content
# https://www.mediawiki.org/wiki/Manual:Categorylinks_table
# 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;

SQL

Checking query status...