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
.
Pairs of edits (same actor, nearby timestamp) in which one creates a substantial mainspace page (or expands a small one) and the other removes text from a similarly sized other page leaving it small
Toggle Highlighting
SQL
SELECT RCa.rc_timestamp, actor_name, RCa.rc_title, RCd.rc_namespace, RCd.rc_title FROM recentchanges RCa JOIN recentchanges_userindex RCd ON RCd.rc_actor = RCa.rc_actor AND RCd.rc_timestamp BETWEEN RCa.rc_timestamp - 1000 AND RCa.rc_timestamp + 1000 /* ±10 minutes, or when the hour ticks over */ AND RCd.rc_type = 0 AND RCd.rc_namespace IN (0, 2, 118) /* Main, User:, Draft: */ AND RCd.rc_old_len > 10000 AND RCd.rc_new_len < 1000 AND RCd.rc_old_len BETWEEN RCa.rc_new_len - 100 AND RCa.rc_new_len + 100 AND RCa.rc_new_len > 10000 /* New text is long */ AND ((RCa.rc_type = 0 AND RCa.rc_old_len < 1000) OR RCa.rc_type = 1) /* Old text was short, or new page */ JOIN actor ON actor_id = RCa.rc_actor WHERE rc_timestamp >= "20220925120000" LIMIT 10;
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...