أكثر المستخدمون مراجعة لمقالات الجدد حول الأعلام منذ يونيو 2018

SQL

use arwiki_p;
select CONCAT('[[مستخدم:',user_name,'|',user_name,']]'), COUNT(*)
from logging
inner join user
on user.user_id = logging.log_user
INNER JOIN revision ON rev_page = log_page
where log_action = "approve-i"
and log_namespace = 0
and log_page in (select cl_from from categorylinks where cl_to like "%أشخاص_على_قيد_الحياة%" and cl_from = log_page)
AND rev_parent_id = 0
and rev_timestamp BETWEEN 20180601000000 AND 20181109000000
group by logging.log_user
having COUNT(*)>1
ORDER BY COUNT(*) DESC
LIMIT 100;

SQL

Checking query status...