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 '%X3%'
and (select count(*) from archive_compat where ar_namespace=log_namespace and ar_title=log_title and ar_user_text="Geo_Swan") > 0
order by log_timestamp desc;
SQL

Checking query status...
