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

SQL

USE arwiki_p;
# by actor_name in actor table 
# https://www.mediawiki.org/wiki/Manual: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;

# by user_name in user table
# https://www.mediawiki.org/wiki/Manual:User_table
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...