USE arwiki_p;

# by actor_name in actor table 

# https://www.mediawiki.org/wiki/Manual:Actor_table

select actor_name, count(actor_name)

​

from revision 

​

join actor on actor_id = rev_actor

​

where rev_timestamp between 20250101000000 AND 20251231235959

and rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "بوابة_طب/مقالات_متعلقة") 

​

group by actor_name

ORDER BY count(actor_name) desc

​

limit 100;

​

# by user_name in user table

# https://www.mediawiki.org/wiki/Manual:User_table

select user_name, count(user_name)

​

from revision 

​

join actor on actor_id = rev_actor

join user on user_id = actor_user

​

where rev_timestamp between 20250101000000 AND 20251231235959

and rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "بوابة_طب/مقالات_متعلقة") 

​

group by user_name

​

ORDER BY count(user_name) desc

​

limit 100;