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

SQL

use arwiki_p;
select actor_name, count(rev_id)
from revision
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 rev_timestamp like "2019%"
group by actor_name
order by count(rev_id) desc 
limit 500;

SQL

Checking query status...