من يحق له الترشيح في ويكي مصدر

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 countall, 
from actor  
JOIN revision ON actor_id = rev_actor
JOIN page ON rev_page = page_id
WHERE   page_namespace in (0, 102, 104, 106)
-- and  not (page_title  like '%شرح')
-- and  (page_title  like '%.js' OR page_title  like '%.css')
 and 
actor_user not in (select ug_user from user_groups as ug2 where ug_group = "bot")
-- and actor_user not in (select ufg_user from user_former_groups as ufg2 where ufg_group = "bot")
-- and rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -5 Year), "%Y%m%d%H%i%s")
group by actor_name
order by 3 desc
limit 20
SQL

Checking query status...
