Wikipedia:Database reports/Possibly out-of-process deletions/X3

X3 requires that the page not contain substantive page history. This requirement was overlooked in a recent batch deletion. Query originally by User:A smart kitten.

This includes pages deleted as X3 with at least 2 revisions more than 200 bytes long. This has some false positives.

{{database report

| 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 where ar_namespace=log_namespace and ar_title=log_title and ar_len>200) > 1

order by log_timestamp desc;

|wikilinks=2:c1:show,3:2|hide=1|interval=3}}

class="wikitable sortable" style="overflow-wrap: anywhere"
scope="col" | Page ! scope="col" | Deleting admin ! scope="col" | Edit summary ! scope="col" | Timestamp
Artemis(mythology) | BusterD | X3: Redirect with no space before a parenthetical disambiguation | 2025-06-08 18:13

----

{{Database report/footer|count=1|query_runtime=8.99|last_updated=05:25, 26 June 2025 (UTC)}}