use ruwiki_p;

select actor_name, count(*) c from 

(select * from logging

 where log_timestamp like "2023%"

 and log_action = "delete") t

join actor_logging on log_actor=actor_id

group by actor_name order by c desc

LIMIT 10;