Top editors in Module namespace arwiki

Fork of Editors with more than 5 edits in last 30 days (arwiki) by علاء

This query is marked as a draft This query has been published by حبيشان.

SQL

-- USE arwiki_p;
select actor_name,  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 (828)
-- and  not (page_title  like '%شرح')
-- and  (page_title  like '%.js')
-- actor_user in (select ug_user from user_groups as ug2 where ug_group = "bot")
actor_name = 'Mr.Ibrahembot'
-- 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 - 1 Year), "%Y%m%d%H%i%s")
group by actor_name
order by c desc
limit 20

SQL

Checking query status...