use arwiki_p;

select actor_name, count(actor_name)

FROM revision

JOIN page ON rev_page = page_id

join actor on actor_id = rev_actor

WHERE page_namespace = 0

AND rev_parent_id = 0

and rev_timestamp BETWEEN 20220101000000 AND 20221231235959

AND page.page_is_redirect = 0

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

group by actor_name

ORDER BY count(actor_name) desc;