Sample from tagged revisions

SQL

# Count failed
# Adding "AND RAND() < 0.001" changes from 0.26 secs to 342 secs
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 change_tag ON change_tag.ct_rev_id = revision.rev_id
JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id
WHERE change_tag_def.ctd_name IN ("possible vandalism", "possible libel or vandalism", "Possible vandalism", "shouting")
AND revision.rev_deleted = 0
AND RAND() < 0.001
LIMIT 10000;
SQL

Checking query status...
