Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Pppery
.
Toggle Highlighting
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) or (select count(*) from archive where ar_namespace=0 and ar_title=log_title) > 5) and exists (select 1 from archive where ar_namespace=0 and ar_title=log_title and ar_timestamp < log_timestamp-1000000) -- Exclude mainspace username redirects, which there are stupidly many of -- - (Batch 1: Creator's username in title) and not exists (select 1 from archive join actor_archive on actor_id=ar_actor where ar_namespace=0 and ar_title=log_title and actor_name=replace(SUBSTRING_INDEX(log_title,"/",1),"_"," ") and ar_parent_id=0) -- - (Batch 2: Moved to slashless title (case insensitive)) and not exists (select 1 from logging_logindex mv where mv.log_namespace=0 and mv.log_title=q.log_title and mv.log_type="move" and mv.log_action="move" and LOWER(CONVERT(mv.log_params using latin1)) like concat("%\"", LOWER(SUBSTRING_INDEX(CONVERT(q.log_title using latin1),"/",-1)),"\"%")) and log_namespace=0 and log_timestamp like CONCAT(YEAR(CURDATE()),LPAD(MONTH(CURDATE()),2,"0"),"%") order by log_timestamp desc;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...