WPCleaner large edits

Lists revisions in mainspace with the WPCleaner tag (id 47) which are 10,000+ bytes larger than the previous version.

SQL

SELECT page_title, Rn.rev_timestamp, Rn.rev_id, actor_name, Rn.rev_len, old_len=(SELECT Ro.rev_len FROM revision Ro WHERE Ro.rev_id=Rn.rev_parent_id)
FROM  revision Rn
JOIN change_tag ON ct_rev_id = Rn.rev_id AND ct_tag_id = 47
JOIN page ON page_id = rev_page AND page_namespace = 0
JOIN actor ON actor_id = rev_actor
WHERE Rn.rev_len > (SELECT Ro.rev_len FROM revision Ro WHERE Ro.rev_id=Rn.rev_parent_id) + 10000
AND (SELECT Ro.rev_len FROM revision Ro WHERE Ro.rev_id=Rn.rev_parent_id) > 0
LIMIT 100;

SQL

Checking query status...