use arwiki_p;

select CONCAT('[[مستخدم:',user_name,'|',user_name,']]'), COUNT(*)

from logging

inner join user

on user.user_id = logging.log_user

where log_timestamp BETWEEN 20190916000000 AND 20190922000000

and log_action = "approve"

and log_namespace = 0

group by logging.log_user

having COUNT(*)>1

ORDER BY COUNT(*) DESC

LIMIT 10;