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 20230729000000 AND 20230730000000

and log_action = "approve"

and log_namespace = 0

group by logging.log_user

having COUNT(*)>1

ORDER BY COUNT(*) DESC

LIMIT 100;