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
CommanderWaterford
.
Toggle Highlighting
SQL
use enwiki_p; select actor_name as editor, COUNT(rev_actor) as accepts, (select COUNT(rc_id) from recentchanges_userindex where rc_actor = actor_id ) as recent_edits from revision_userindex left join actor on rev_actor = actor_id where (rev_page = 21063913) and (rev_timestamp >= DATE_ADD(NOW(), INTERVAL -2 MONTH) ) group by rev_actor order by accepts desc, recent_edits;
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...