Sample revisions of Objectionable Content

SQL

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

SELECT @min := MIN(rev_id), @max := MAX(rev_id) FROM revision;

SELECT 
	DISTINCT 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
JOIN (SELECT FLOOR(@min + (@max - @min + 1) * RAND(1)) AS rev_id FROM revision LIMIT 5000) AS random USING (rev_id)
WHERE rev_deleted = 0 
AND categorylinks.cl_to = "Wikipedia_objectionable_content"
LIMIT 5000;
SQL

Checking query status...
