template subpage deletion

This query is marked as a draft This query has been published by HTinC23.

SQL

select concat("Template:",replace(log_title,"_"," ")) as 'Page',
(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",
comment_text as "Edit summary",
log_timestamp as "Timestamp" from logging_logindex q join comment_logging on comment_id=log_comment_id
where log_type="delete" and log_action="delete" and log_namespace=10 and 
  (comment_text like "%G15%") and not (comment_text like "%定向%")
and log_timestamp like "202%"
and log_title like "%/%"
order by log_timestamp desc;

SQL

Checking query status...