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

SQL

USE arwiki_p;
# by actor_name in actor table 
select actor_name, count(actor_name)
from revision 
join actor on actor_id = rev_actor
where rev_timestamp between 20170101000000 AND 20171231235959
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 100;


select user_name, count(user_name)
from revision 
join actor on actor_id = rev_actor
join user on user_id = actor_user
where rev_timestamp between 20170101000000 AND 20171231235959
and rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "بوابة_طب/مقالات_متعلقة") 
group by user_name
ORDER BY count(user_name) desc
limit 100;

SQL

Checking query status...