use arwiki_p;

select concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(rev_id) AS "عدد المقالات"

from revision r

inner join actor

on actor_id = rev_actor

inner join page p1

on p1.page_id = rev_page

where p1.page_id in

(select cl_from from categorylinks 

 where cl_to = "ويكي_غاب_عمان_2020")

and p1.page_is_redirect = 0

and r.rev_parent_id =0

#and rev_timestamp like "2020%"

group by actor_name

order by count(rev_id) desc 

limit 500;