use arwiki_p;

select actor_name, count(rev_id)

from revision

inner join actor

on actor_id = rev_actor

inner join page p1

on p1.page_id = rev_page

where (select p2.page_id from page p2 

       where p2.page_title = p1.page_title 

       and p2.page_namespace = (p1.page_namespace+1) 

       and p2.page_is_redirect = 0)  

in

(select cl_from from categorylinks 

 where cl_to = "مقالات_مشروع_ويكي_الجزائر")

and p1.page_is_redirect = 0

and rev_timestamp like "2024%"

group by actor_name

order by count(rev_id) desc 

limit 500;