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
Blahma
.
Discriminate bots manually. When forking, please adapt wiki and dates at the top. If applicable, fix timezone (currently set to CEST for the whole year).
Toggle Highlighting
SQL
USE cswiki_p; set @begin = '20150101000000', @end = '20160101000000'; SELECT user_name, COUNT(*) AS edits FROM revision JOIN user ON rev_user = user_id WHERE rev_timestamp BETWEEN 0+DATE_SUB(@begin, INTERVAL 2 HOUR) AND 0+DATE_SUB(DATE_SUB(@end, INTERVAL 2 HOUR), INTERVAL 1 SECOND) GROUP BY user_name ORDER BY edits 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...