use ruwiki;

select actor_name, count(*) c from logging join actor_logging on log_actor=actor_id where log_action = "delete"

and log_timestamp >= "20230101000000" and log_timestamp < "20240101000000" 

group by actor_name order by c desc;