Replicas browser and optimizer
This query is marked as a draft
This query has been published
SELECT log_namespace, log_title, log_comment, IF(log_comment REGEXP "WP:CSD#G3\\|", "vandalism", IF(log_comment REGEXP "WP:CSD#G10\\|", "attack", IF(log_comment REGEXP "WP:CSD#G11\\|", "spam", IF(log_comment REGEXP "WP:CSD#A11\\|", "hoax", "other")))) AS deletion_reason FROM logging WHERE log_type = "delete" AND log_action = "delete" AND log_timestamp BETWEEN "20150901" AND "20160901" AND log_comment LIKE "[[WP:CSD#%" AND log_comment REGEXP "WP:CSD#(G3|G10|G11|A11)\\|";
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in