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
Cryptic
.
My CSD A-series speedy deletions of pages not in the main namespace, which weren't also labelled G1 or G10-G14. For [[w:en:WT:CSD#Talk pages of nonexistent articles that are written as articles and would be speedy deletable as articles]] circa 24 Feb 2019.
Toggle Highlighting
SQL
SELECT CONCAT('[[', CASE log_namespace WHEN 1 THEN 'Talk:' WHEN 4 THEN 'WP:' WHEN 5 THEN 'WT:' WHEN 6 THEN ':File:' WHEN 14 THEN ':Category:' WHEN 10 THEN 'Template:' WHEN 118 THEN 'Draft:' ELSE CONCAT('{{ns:', log_namespace, '}}:') END, log_title, ']]') AS page, log_timestamp, comment_text FROM logging_userindex JOIN comment ON comment_id=log_comment_id WHERE log_user_text='Cryptic' AND log_type='delete' AND log_action='delete' AND (comment_text LIKE '%[[WP:CSD#A%' OR comment_text LIKE '%[[WP:A%') AND comment_text NOT LIKE '%[[WP:CSD#G1%' AND log_namespace != 0 ORDER BY log_timestamp ASC;
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...