أكثر الصفحات تعديلًا خلال يوم

SQL

use arwiki_p;
select concat("[[",page_title,"]]") as "الصفحة", concat("[[خاص:تاريخ/",page_title,"]]") as "وصلة التاريخ", count(*) as "عدد التعديلات"
from revision
inner join page
on page_id = rev_page
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and page_namespace = 0
and ((rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%autoreview%")
	and rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%editor%")
     )
    or
     (rev_user = 0))
group by page_title
order by count(*) desc
limit 100;

SQL

Checking query status...