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
Muhdusman
.
Toggle Highlighting
SQL
use huwiki_p; select T.user_id, T.user_name, count(*) as edit_count from ( select * from revision inner join user on rev_user=user_id left join user_groups on user.user_id=user_groups.ug_user and ug_group = 'bot' WHERE rev_timestamp > (NOW() - INTERVAL 30 DAY + 0) and ug_group is null order by rev_timestamp desc ) as T group by T.rev_user order by edit_count 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...