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

SQL

use arwiki_p;
select concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(rev_id) AS "عدد المقالات"
from revision r
inner join actor
on actor_id = rev_actor
inner join page p1
on p1.page_id = rev_page
where (select p2.page_id from page p2 
       where p2.page_title = p1.page_title 
       and p2.page_namespace = (p1.page_namespace+1) 
       and p2.page_is_redirect = 0)  
in
(select cl_from from categorylinks 
 where cl_to = "مقالات_مشروع_ويكي_طب")
and p1.page_is_redirect = 0
and r.rev_parent_id =0
and rev_timestamp like "2020%"
group by actor_name
order by count(rev_id) desc 
limit 10;

SQL

Checking query status...