edits in various namespaces

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.

SQL

use trwiki_p;
SELECT NOW();
SELECT hep.rchep as kul, rc0.rc_user_text, hep.ec
, count(rc0.rc_id) as ec0
, count(rc2.rc_id) as ec2

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
left join recentchanges_userindex rc2 on rc2.rc_user = hep.rchep
where rc0.rc_namespace = 0
and rc2.rc_namespace = 2
group by kul, kul, kul
LIMIT 10;
SELECT NOW();

SQL

Checking query status...