Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Users with the most edits in last month
by
Edgars2007
This query is marked as a draft
This query has been published
by
Bulgu
.
Toggle Highlighting
SQL
use trwiki_p; SELECT NOW(); SELECT hep1.kul as kul, hep1.ec as ec, hep1.ec0 as ec0, hep1.ec2 as ec2, hep1.ec1 as ec1 , count(rc828.rc_id) as ec828 from (SELECT hep2.kul as kul, hep2.ec as ec, hep2.ec0 as ec0, hep2.ec2 as ec2 , count(rc1.rc_id) as ec1 from (SELECT hep0.kul as kul, hep0.ec as ec, hep0.ec0 as ec0 , count(rc2.rc_id) as ec2 from (SELECT hep.kul as kul, rc0.rc_user_text as kulad, hep.ec as ec , count(rc0.rc_id) as ec0 from (SELECT rc.rc_user as kul, count(*) as ec from recentchanges_userindex rc where rc.rc_user >0 and rc.rc_bot = 0 group by kul having count(*) > 3000) as hep left join recentchanges_userindex rc0 on rc0.rc_user = hep.kul where rc0.rc_namespace = 0 group by kul) as hep0 left join recentchanges_userindex rc2 on rc2.rc_user = hep0.kul where rc2.rc_namespace = 2 group by kul) as hep2 left join recentchanges_userindex rc1 on rc1.rc_user = hep2.kul where rc1.rc_namespace IN (1,3,5,7,9,11,13,15,101,829) group by kul) as hep1 left join recentchanges_userindex rc828 on rc828.rc_user = hep1.kul where rc828.rc_namespace = 828 group by kul ; SELECT NOW();
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...