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.*, change_tag.*, change_tag_def.* 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 rev_id < 200000000; # took 29 seconds and empty
#AND rev_id >= 200000000 AND rev_id < 300000000; # took 111 seconds
#AND rev_id >= 300000000 AND rev_id < 350000000; # took 1166 seconds
#AND rev_id >= 350000000 AND rev_id < 400000000; # took 1744 seconds
AND rev_id >= 400000000 AND rev_id < 450000000; # took  seconds
#AND rev_id >= 450000000 AND rev_id < 500000000; # took  seconds
#AND rev_id >= 500000000 AND rev_id < 550000000; # took  seconds
#AND rev_id >= 550000000 AND rev_id < 600000000; # took  seconds
#AND rev_id >= 600000000 AND rev_id < 650000000; # took  seconds
#AND rev_id >= 800000000; # took  seconds
SQL

Checking query status...
