Untitled query #67999

SQL

select log_title as 'Page',
(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",
comment_text as "Edit summary",
DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i') as "Timestamp" 
from logging_logindex q join comment_logging on comment_id=log_comment_id
where log_type="delete" and log_action="delete"
and 
  (comment_text like "%G6%")
   -- and (select count(*) from archive where ar_namespace=log_namespace and ar_title = log_title and ar_actor != log_actor) > 10
   and not (log_title like "%-%" and exists (select 1 from archive where ar_namespace=log_namespace and ar_title=log_title and ar_actor=
                                         (select actor_id from actor where actor_name="AnomieBOT") and ar_parent_id=0))
   and not (comment_text regexp -- "Deleting templates orphaned as the result of a consensus at WP:TfD. (generalizing to other fora)"
   "\\[\\[Wikipedia:(Articles[ _]for[ _]deletion{{!}}Redirects[ _]for[_ ]discussion)")

and not exists (select 1 from page where page_namespace=0 and page_title=log_title)
and exists (select 1 from archive where ar_namespace=0 and ar_title=log_title and ar_timestamp < log_timestamp-1000000)
and (log_title regexp ".*\\([^)]*")
and log_namespace=0
and log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s')
order by log_timestamp desc;
SQL

Checking query status...
