Search SpeedyDelete (CSD) by Page Titles - Quarry

Fork of Search SpeedyDelete (CSD) by Page Titles by Dwmc

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

Sample query to search the speedy deletion logs for article titles

SQL

SELECT * FROM logging WHERE 
	log_type = "delete" AND
    log_action = "delete" AND
    log_namespace = 0 AND # Only consider pages speedy deleted in the Article namespace
    log_comment RLIKE "WP:CSD#[AG][0-9]+" AND # Match codes for speedy delete General and Articles
    # see https://en.wikipedia.org/wiki/Wikipedia:Criteria_for_speedy_deletion
    log_title LIKE "%Bally_shoe_factories%";

AخA
 
SELECT * FROM logging WHERE     log_type = "delete" AND    log_action = "delete" AND    log_namespace = 0 AND # Only consider pages speedy deleted in the Article namespace    log_comment RLIKE "WP:CSD#[AG][0-9]+" AND # Match codes for speedy delete General and Articles    # see https://en.wikipedia.org/wiki/Wikipedia:Criteria_for_speedy_deletion    log_title LIKE "%Bally_shoe_factories%";

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