SQL
AخA
USE arwiki_p;
select rev_user_text, count(rev_user_text)
from revision
where rev_timestamp between 20180101000000 AND 20181231235959
and rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "بوابة_طب/مقالات_متعلقة")
group by rev_user_text
ORDER BY count(rev_user_text) desc
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.