edits in various namespaces

SQL

use trwiki_p;
SELECT NOW();
SELECT concat('* [[User:',u.user_name,'|]]'), u.ec
-- ,COUNT(DISTINCT u.user_id from u where u.rc_namespace=0 ) as ecmad
/*,COUNT(SELECT u.user_id from u where u.rc_namespace=2 group by 1) as eckul
,COUNT(SELECT u.user_id from u where u.rc_namespace=4 group by 1) as ecvik
,COUNT(SELECT u.user_id from u where u.rc_namespace=6 group by 1) as ecdos
,COUNT(SELECT u.user_id from u where u.rc_namespace=10 group by 1) as ecsab
,COUNT(SELECT u.user_id from u where u.rc_namespace=14 group by 1) as eckat
,COUNT(SELECT u.user_id from u where u.rc_namespace=828 group by 1) as ecmod
*/

from (SELECT *,count(*) as ec from user join recentchanges on rc_user = user_id 
 where user_id>0 and user_name not rlike "[B][Oo][Tt]" group by user_id having ec>5 order by ec desc) as u
left join recent_changes r0 on r0.rc_user = u.user_id left join recent_changes r2 on r2.rc_user = u.user_id
left join recent_changes r4 on r4.rc_user = u.user_id left join recent_changes r6 on r6.rc_user = u.user_id
left join recent_changes r10 on r10.rc_user = u.user_id left join recent_changes r14 on r14.rc_user = u.user_id
left join recent_changes r828 on r828.rc_user = u.user_id left join recent_changes r1 on r1.rc_user = u.user_id

where 
r0.rc_namespace = 0 and r2.rc_namespace = 2 and
r4.rc_namespace = 4 and r6.rc_namespace = 6 and
r10.rc_namespace = 10 and r14.rc_namespace = 14 and
r828.rc_namespace = 828 and r1.rc_namespace IN (1,3,5,7,11,15,829)

GROUP BY 1 ORDER BY 2 DESC
LIMIT 100;
SELECT NOW();
SQL

Checking query status...
