Untitled query #67999

SQL

select log_title as "Page",actor_name,
(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",
comment_text as "Edit summary",
log_timestamp as "Timestamp",
rev_id
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()),"%")
order by log_timestamp desc;
SQL

Checking query status...
