Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Marathi Wikipedia top editors sorted by total number of edits
by
Tiven2240
This query is marked as a draft
This query has been published
by
Arjunaraoc
.
Editors exceeding 100 edits before a date
Toggle Highlighting
SQL
use tewiki_p; select rev_actor, actor_name, count(rev_id) as edit_count from revision, actor where rev_timestamp < 20200701000000 and rev_actor = actor_id and (NOT LOWER(actor_name) LIKE "%bot") group by rev_actor having count(rev_id) >= 100 order by edit_count desc LIMIT 100;
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...