edits in various namespaces

SQL

use trwiki_p;
SELECT NOW();
SELECT hep2.kul, hep2.ec , hep2.ec0 , hep2.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
            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 hep.kul) as hep0
      left join recentchanges_userindex rc2 on rc2.rc_user = hep0.kul
      where rc2.rc_namespace = 2
      group by hep0.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 hep2.kul
      
;
SELECT NOW();
SQL

Checking query status...
