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
MMiller (WMF)
.
Toggle Highlighting
SQL
use kowiki_p; select edits, count(log_user) as total from ( select l.log_user, sum(r.edits) as edits from logging l left join (select rev_user, count(*) as edits from revision where rev_user != 0 and rev_timestamp > 20171200000000 group by 1) r on l.log_user = r.rev_user where l.log_action = 'create' AND l.log_type='newusers' and l.log_timestamp >= 20180100000000 and l.log_timestamp < 20180200000000 group by 1 ) a group by 1 order by 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...