edits in various namespaces

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
,sum(1-hep1.rc_bot) as ec828
from (SELECT hep2.kul as kul, hep2.ec as ec, hep2.ec0 as ec0, hep2.ec2 as ec2, hep2.rc_bot as rc_bot
, sum(1-hep2.rc_bot) as ec1
from (SELECT hep0.kul as kul, hep0.ec as ec, hep0.ec0 as ec0, hep0.rc_bot as rc_bot
      , sum(1-hep0.rc_bot) as ec2
      from (SELECT hep.kul as kul, rc0.rc_user_text as kulad, hep.ec as ec, hep.rc_bot as rc_bot
            , sum(1-hep.rc_bot) as ec0
            from (SELECT rc.rc_user as kul, count(*) as ec, rc.rc_bot as rc_bot  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 IN (2,3)
      group by kul) as hep2
left join recentchanges_userindex rc1 on rc1.rc_user = hep2.kul
where rc1.rc_namespace IN (1,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 is null OR rc828.rc_namespace IN ( 828, 829,1) 
group by kul
      
;
SELECT NOW();
SQL

Checking query status...
