Untitled query #67999

SQL

select log_title as "Page",
(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",
(select count(*) from revision_userindex join page on rev_page=page_id where rev_actor=(
  select actor_id from actor_revision where actor_name=replace(SUBSTRING_INDEX(log_title, "/",1),"_"," ")
) and page_namespace not in (2,3)) as "Number of non-userpage edits",
comment_text as "Edit summary",
log_timestamp as "Timestamp" from logging_logindex join comment_logging on comment_id=log_comment_id
where log_type="delete" and log_action="delete"
and (comment_text like "%U5%")
and (select count(*) from revision_userindex join page on rev_page=page_id where rev_actor=(
  select actor_id from actor_revision where actor_name=replace(SUBSTRING_INDEX(log_title, "/",1),"_"," ")
) and page_namespace not in (2,3) limit 15) > 100
and log_timestamp like CONCAT(YEAR(CURDATE()),MONTH(CURDATE()),"%")
order by log_timestamp desc;
SQL

Checking query status...
