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
Chaduvari
.
Toggle Highlighting
SQL
select * /*sum(tdif)*/ from (select actor_name, sum( cast(rc_new_len as int) - cast(rc_old_len as int)) tdif from recentchanges_userindex left join actor on rc_actor = actor_id where rc_timestamp >= 20230600000000 and rc_timestamp <= 20240100000000 and rc_bot = 0 and (rc_source = 'mw.new' or rc_source='mw.edit') and rc_namespace=0 group by actor_name) a where tdif >= 30000 order by tdif desc
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...