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 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.rchep as kul, rc0.rc_user_text as kulad, hep.ec as ec , count(rc0.rc_id) as ec0 -- , hep.ec - count(rc0.rc_id) as diger, round(count(rc0.rc_id)*100/hep.ec,2) as yuzde0 from (SELECT rc.rc_user as rchep, count(*) as ec from recentchanges_userindex rc where rc.rc_user >0 and rc.rc_bot = 0 group by rchep having count(*) > 3000) as hep left join recentchanges_userindex rc0 on rc0.rc_user = hep.rchep where rc0.rc_namespace = 0 group by 1) as hep0 left join recentchanges_userindex rc2 on rc2.rc_user = hep0.kul where rc2.rc_namespace = 2 group by 1) 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 1 ; 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...