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

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

Checking query status...
