Untitled query #6826

SQL

USE ptwiki_p; 



select  ANO, MES, count(*) from 

(select rev_user, MES, ANO, count(*) as edicoes from 


( select rev_user, EXTRACT(MONTH FROM CAST(r.rev_timestamp AS DATETIME)) AS MES, EXTRACT(YEAR FROM CAST(r.rev_timestamp AS DATETIME)) AS ANO from revision r inner join page on rev_page = page_id where page_namespace in (0,102) and rev_user not in (select ug_user from user_groups where ug_group = 'bot') and (rev_timestamp > 20150501000000 and rev_timestamp < 20160101000000) 

) a
group by rev_user, MES, ANO) b

 where edicoes > 99

GROUP BY ANO, MES
;
SQL

Checking query status...
