WP:Database reports/Possibly out-of-process deletions#G6

Limited to mainspace pages that were more than one day old at the time of deletion and don't currently exist to keep the number of entries manageable.

{{database report|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 join comment_logging on comment_id=log_comment_id

where log_type="delete" and log_action="delete"

and (comment_text not like "%[WP:CSD%"

and comment_text not regexp "\\[\\[WP:[GARX][0-9]{1,2}.*"

and comment_text not regexp "^\\[\\[(Wikipedia{{!}}WP):(Articles[ _]for[ _]deletion{{!}}Redirects[ _]for[ _]discussion).*"

and comment_text not like "_er outcome of WP:RFD" -- Odd format used by BD2412

and comment_text not regexp "Expired ?\\[\\[WP:PROD{{!}}PROD\\]\\]%"

and comment_text not like "Multiple reasons: speedy deletion criteria%"

and comment_text not like "Listed at Wikipedia:Copyright problems for over seven days%" -- MER_C's format

and comment_text not like "%with extensive history of copyright violations%" -- MER_C's newer format

and comment_text not like "%isted at WP:CP%" -- Premeditated Chaos' format

and comment_text not like "%BLPPROD%"

and comment_text not regexp ".*[Gg][35].*" -- these tend to use odd formats, so exclude them

and comment_text not regexp "^(CSD )?[GARXgarx][0-9]{1,2}(${{!}}[.,/])?" -- exclude cases containing just a code, or a code followed

-- by an explanation with a comma, period or slash. I deliberately don't exclude just [GARgar][0-9]{1,2} as that's

-- too broad and risks too many false negatives

)

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 not exists (select 1 from page where page_namespace=0 and page_title=log_title)

-- Exclude mass deletions of pages created by socks

and exists (select 1 from archive where ar_namespace=0 and ar_title=log_title and ar_timestamp < log_timestamp-1000000)

and not (comment_text like "%Mass deletion%" and exists (

select comment_text from actor_archive join archive on ar_actor=actor_id join block_target on bt_user=actor_user join block on bl_target=bt_id

join comment_block on comment_id=bl_reason_id

where ar_namespace=0 and ar_title=log_title and ar_parent_id=0

and (comment_text like "%Sockpuppet%investigations%" or comment_text like "%multiple%accounts%" or comment_text like "%checkuser%" or comment_text like "%ock%puppetry%" or comment_text like "%ong%term%abuse")

))

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;

|wikilinks=1:0,2:2|interval=3}}

----

{{Database report/footer|count=8|query_runtime=1.02|last_updated=09:26, 27 June 2025 (UTC)}}

{{database report end}}

Limited to mainspace pages that were more than one day old at the time of deletion and don't currently exist to keep the number of entries manageable.

{{database report|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 log_title not like "%/temp"

and exists (select 1 from archive where ar_namespace=0 and ar_title=log_title and ar_timestamp < log_timestamp-1000000)

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;

|wikilinks=1:0,2:2|interval=3}}

----

{{Database report/footer|count=16|query_runtime=1.13|last_updated=09:34, 25 June 2025 (UTC)}}

{{database report end}}

A10 or R3 deletions of not recently created pages. "Not recently created" means more than 4 months old at the time of deletion. (The exact wording of "recently" is somewhat vague in the criterion itself.)

R2 is also included here, since legitimate R2 deletions usually happen in days, and months-old revisions deleted under an R2 may imply an admin failed to check the history before deleting.

G3 is also included here, to check for cases where a page is vandalized and an admin deleted rather than reverting the vandalism, and as a reminder to update WP:HOAXLIST for old hoaxes.

{{database report|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 curdel join comment_logging on comment_id=log_comment_id

where log_type="delete" and log_action="delete"

and (comment_text like "%A10%" or comment_text like "%R3%" or comment_text like "%R2%" or comment_text like "%G3%")

-- The modulo and subtraction of 8800000000 handle year wraparound properly since years don't have 100 months

and exists (select 1 from archive where ar_namespace=log_namespace and ar_title=log_title

and ar_timestamp < IF((log_timestamp - 400000000 - 100000000) % 10000000000 > 1200000000,

log_timestamp - 400000000 - 8800000000,

log_timestamp - 400000000)

and ar_timestamp > COALESCE((select max(log_timestamp) from logging_logindex prevdel where (prevdel.log_type="delete" and

prevdel.log_action="delete" and

prevdel.log_namespace=curdel.log_namespace and

prevdel.log_title=curdel.log_title and

prevdel.log_timestamp

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;

|wikilinks=1:0,2:2|interval=3}}

----

{{Database report/footer|count=2|query_runtime=1.00|last_updated=01:25, 25 June 2025 (UTC)}}

{{database report end}}

This section lists deletions of G13 that don't appear to actually meet the criterion because there were less than 6 months since the last human edit to the page (other than a possible CSD tagging).

{{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 curdel join comment_logging on comment_id=log_comment_id

where log_type="delete" and log_action="delete"

and (comment_text like "%G13%")

-- The modulo and subtraction of 8800000000 handle year wraparound properly since years don't have 100 months

and exists (select 1 from archive where ar_namespace=log_namespace and ar_title=log_title

and ar_timestamp > IF((log_timestamp - 600000000 - 100000000) % 10000000000 > 1200000000,

log_timestamp - 600000000 - 8800000000,

log_timestamp - 600000000) + 2000000 -- 2 days of slop

and not exists (select 1 from user_groups join actor_archive on actor_user=ug_user where actor_id=ar_actor and ug_group="bot")

and ar_timestamp < log_timestamp - 1000000 -- Exclude what looks like human taggings

)

and log_namespace % 2 = 0

and log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s')

|wikilinks=2:c1:show,3:2

|interval=3|hide=1}}

----

{{Database report/footer|count=2|query_runtime=1.86|last_updated=01:25, 25 June 2025 (UTC)}}

{{database report end}}

Shows all U5 deletions where the user in question has more than 100 edits outside of user (and user talk) space. See Wikipedia talk:Criteria for speedy deletion/Archive 84#Quantifying "few or no other edits" in U5

For arcane technical reasons this table is limited to a max of 200 entries. If more than 200 would display, then the 200 with the highest edits do.

{{database report|sql=

select log_namespace as "Namespace",log_title as "Page", dadm as "Deleting admin",

comment_text as "Edit summary",

DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i') as "Timestamp",

revcount as "Number of non-userspace edits"

from (select

log_namespace, log_title,

(select actor_name from actor_logging where actor_id=log_actor) as dadm,

comment_text,

log_timestamp,

(select count(*) from revision_userindex join page on rev_page=page_id

where rev_actor=actor_id and page_namespace not in (2,3)) as revcount

from logging_logindex join comment_logging on comment_id=log_comment_id

join actor_revision on actor_name=replace(SUBSTRING_INDEX(log_title, "/",1),"_"," ")

where log_type="delete" and log_action="delete"

and (comment_text like "%U5%")

and log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s')

order by revcount desc limit 200

) as rdels

where revcount > 100

order by log_timestamp desc;

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

----

{{Database report/footer|count=4|query_runtime=4.32|last_updated=09:34, 25 June 2025 (UTC)}}

{{database report end}}

For example, using a CSD criteria that starts with A (article) to delete something in draftspace. Also note that G1 and G2 may not be used in userspace.

{{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_type="delete" and log_action="delete"

and (

-- -- Speedy deletions

-- Generic category checks

(comment_text rlike "WP:(CSD#)?A[0-9]+" and log_namespace != 0) -- A* criteria only apply to mainspace

or (comment_text rlike "WP:(CSD#)?F[0-9]+" and log_namespace != 6) -- F* criteria only apply to files (primarily for completeness' sake, has no results in 2022 and only 4 in 2021)

or (comment_text rlike "WP:(CSD#)?C[0-9]+" and log_namespace != 14) -- C* criteria only apply to categories

or (comment_text rlike "WP:(CSD#)?U[0-9]+" and log_namespace != 2 and log_namespace != 3) -- U* criteria only apply to userpages

-- Specific criterion checks

or ((comment_text rlike "G1[^0123]" or comment_text like "%G2%") and log_namespace=2) -- G1 and G2 don't apply to userspace

-- or (comment_text like "%G7%" and log_namespace=3) -- G7 can in theory apply to user talk pages but is often misused

or (comment_text like "%G13%" and (log_namespace != 2 and log_namespace != 118)) -- G13 only applies to draft and user space

or (comment_text like "%R2%" and log_namespace != 0)

-- or (comment_text like "%U1%" and log_namespace=3) -- U1 does not apply to user talk pages

-- or (comment_text like "%U5%" and log_namespace=3) -- U1 does not apply to user talk pages

-- -- Deletion discussions

or (comment_text not like "%G8%XFDcloser%" and (

(comment_text like "%Articles_for_deletion%" and log_namespace != 0)

or (comment_text like "%Files_for_discussion%" and log_namespace != 6)

or (comment_text like "%Templates_for_discussion%" and log_namespace != 10 and log_namespace != 828 and log_namespace != 11)

or (comment_text like "%Categories_for_discussion%" and log_namespace != 14 and log_namespace != 15)

or (comment_text like "%Miscellany_for_deletion%" and (log_namespace in (0, 6, 14) or (log_namespace=10 and log_title

not like "User%")))

))

)

and comment_text not like "G8: Deleted together with the associated page with reason%"

and log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s')

order by log_timestamp desc;

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

----

{{Database report/footer|count=25|query_runtime=0.60|last_updated=01:25, 25 June 2025 (UTC)}}

{{database report end}}

{{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

and comment_text regexp ".*WP:(CSD#)?(A[4568]{{!}}R1{{!}}F10{{!}}C3{{!}}T[1234]{{!}}U[34]{{!}}[PX][12]{{!}}PMRC#10).*"

and log_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH), '%Y%m%d%H%i%s')

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

{{Database report/footer|count=0|query_runtime=9.94|last_updated=01:25, 25 June 2025 (UTC)}}

{{database report end}}

See /X3

Normally user talk pages shouldn't be deleted per WP:DELTALK. This lists deleted user talk pages with more than 40 revisions by people other than the user in question, archive bots, or the mass message bot.

{{database report|sql=

select ar_title,count(*),DATE_FORMAT(max(ar_timestamp), '%Y-%m-%d %H:%i') as "Timestamp" from archive where ar_namespace=3

and ar_actor not in (select actor_id from actor_archive where actor_name in (replace(SUBSTRING_INDEX(ar_title,"/",1),"_"," "),

"Lowercase sigmabot III","ClueBot III",

"MediaWiki message delivery","Legobot",

"HBC Archive Indexerbot"))

and (select count(*) from logging_logindex join comment_logging on comment_id=log_comment_id

where log_title=ar_title and log_namespace=3 and log_type="delete" and comment_text like "%G5%") < 2

and (select count(*) from logging_logindex join comment_logging on comment_id=log_comment_id

where log_title=ar_title and log_namespace=3 and log_type="delete" and log_action="delete" and (log_timestamp like "2025%")) > 0

group by ar_title having count(*) > 40

|wikilinks=1:3|interval=3}}

----

{{Database report/footer|count=5|query_runtime=345.33|last_updated=01:31, 27 June 2025 (UTC)}}

{{database report end}}