2019أكثر المستخدمين إنشاءً للمقالات ضمن مشروع ويكي طب - محدث

SQL

use arwiki_p;
SELECT concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(*) AS "عدد المقالات"
FROM revision r
INNER JOIN actor ON r.rev_actor = actor.actor_id
INNER JOIN page p on r.rev_page = p.page_id
WHERE p.page_namespace =0 and p.page_is_redirect =0 and r.rev_timestamp between 20200101000000 AND 20201231235959
and r.rev_parent_id =0
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 50;

SQL

Checking query status...