select log_title as "Page",

(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",

comment_text as "Edit summary",

log_timestamp as "Timestamp",

count(rev_id) as editcount 

from logging_logindex join comment_logging on comment_id=log_comment_id

join actor on actor_name=replace(SUBSTRING_INDEX(log_title, "/",1),"_"," ")

join revision_userindex on rev_actor=actor_user

join page on rev_page=page_id

where page_namespace not in (2,3)

and log_type="delete" and log_action="delete"

and (comment_text like "%U5%")

and log_timestamp like CONCAT(YEAR(CURDATE()),MONTH(CURDATE()),"%")

group by actor_name 

having editcount > 100

order by log_timestamp desc;