Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Certes
.
Lists revisions in mainspace with the WPCleaner tag (id 47) which are 10,000+ bytes larger than the previous version.
Toggle Highlighting
SQL
SELECT page_title, Rn.rev_timestamp, Rn.rev_id, actor_name, Rn.rev_len AS new_len, /* Ro.rev_len AS old_len */ (SELECT Ro.rev_len FROM revision Ro WHERE Ro.rev_id = Rn.rev_parent_id AND Ro.rev_len > 0 AND Rn.rev_len > Ro.rev_len + 10000) AS old_len FROM revision Rn JOIN revision Ro ON Ro.rev_id = Ro.rev_parent_id /* AND Ro.rev_len > 0 AND Rn.rev_len > Ro.rev_len + 10000 */ JOIN change_tag ON ct_rev_id = Rn.rev_id AND ct_tag_id = 47 JOIN page ON page_id = Rn.rev_page AND page_namespace = 0 JOIN actor ON actor_id = Rn.rev_actor WHERE Rn.rev_id >= 903150349 AND Rn.rev_id < 903150350 /* 0 rows, 93 seconds: WHERE Rn.rev_id < 700000000 */ /* 2 rows, 72 seconds: WHERE Rn.rev_id >= 700000000 AND Rn.rev_id < 800000000 */ /* 0 rows, 177 seconds: WHERE Rn.rev_id >= 800000000 AND Rn.rev_id < 900000000 */ /* 12 rows, 67 seconds: WHERE Rn.rev_id >= 900000000 AND Rn.rev_id < 950000000 */ /* rows, seconds: WHERE Rn.rev_id >= 910000000 AND Rn.rev_id < 920000000 */ /* rows, seconds: WHERE Rn.rev_id >= 920000000 AND Rn.rev_id < 930000000 */ /* rows, seconds: WHERE Rn.rev_id >= 930000000 AND Rn.rev_id < 940000000 */ /* rows, seconds: WHERE Rn.rev_id >= 940000000 AND Rn.rev_id < 950000000 */ /* rows, seconds: WHERE Rn.rev_id >= 950000000 AND Rn.rev_id < 960000000 */ /* rows, seconds: WHERE Rn.rev_id >= 960000000 AND Rn.rev_id < 970000000 */ /* rows, seconds: WHERE Rn.rev_id >= 970000000 AND Rn.rev_id < 980000000 */ /* rows, seconds: WHERE Rn.rev_id >= 980000000 AND Rn.rev_id < 990000000 */ /* rows, seconds: WHERE Rn.rev_id >= 990000000 */ HAVING old_len > 0
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...