SQL
AخA
use arwiki_p;
SELECT rev_user_text, count(rev_user_text)
FROM revision
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
AND rev_parent_id = 0
and rev_timestamp BETWEEN 20170101000000 AND 20181231235959
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 rev_user_text
ORDER BY count(rev_user_text) desc;
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.