Untitled query #67999

SQL

select log_title as "Page",log_namespace as "Namespace",
(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 "Number of non-userspace edits"
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_id
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 count(rev_id) > 100
order by log_timestamp desc;
SQL

Checking query status...
