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;