USE arwiki_p;

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

from logging

INNER JOIN actor on logging.log_actor = actor_id

where log_timestamp BETWEEN 20240101000000 AND 20241231235959

and log_type in ("delete")

group by logging.log_actor

having COUNT(*)>1

ORDER BY COUNT(*) DESC

LIMIT 100;