Top editors in Template namespace arwiki

Fork of Top editors in Module namespace arwiki by Mr. Ibrahem

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

-- USE arwiki_p;
select actor_name, case when actor_user in (select ug_user from user_groups as ug2 where ug_group = "sysop") then 'sysop'
					when actor_user in (select ug_user from user_groups as ug2 where ug_group = "templateeditor") then 'templateeditor'
                    else 'other'
                    end as ugroup, count(rev_id) as c
from revision 
JOIN actor ON actor_id = rev_actor
JOIN page ON rev_page = page_id
WHERE page_namespace in (10)
AND page_title NOT REGEXP '^.*?\/(ملعب|مختبر|شرح|sandbox|test)/*.*?$'

and actor_user not like "%bot*
-- and rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL - 1 Year), "%Y%m%d%H%i%s")
group by actor_name
order by 3 desc
limit 20

SQL

Checking query status...