Untitled query #63531

SQL

select log_namespace as "Namespace",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 join comment_logging on comment_id=log_comment_id
where log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s') 
and log_type = 'delete'
and (comment_text like '%IAR%' or coment_text like "%gnore%all%rules")
and (select count(*) from archive where ar_namespace=log_namespace and ar_title=log_title) > 4
order by log_timestamp desc;
SQL

Checking query status...
