Mainspace deletions by month

The number of deletions in each month since the deletion log began in December 2004.

See query 78460 for an attempt to classify the type of deletion using (mostly) the log comments.

For [[WP:RAQ#number of deletions]] circa 2023 Dec 3.

SQL

SELECT CONCAT(LEFT(log_timestamp, 4), '-', SUBSTR(log_timestamp, 5, 2)) AS 'yyyymm',
       COUNT(*) AS 'total deletions'
FROM logging
WHERE log_type = 'delete' AND log_action IN ('delete', 'delete_redir', 'delete_redir2') AND log_namespace = 0
GROUP BY LEFT(log_timestamp, 6);

​x
 
SELECT CONCAT(LEFT(log_timestamp, 4), '-', SUBSTR(log_timestamp, 5, 2)) AS 'yyyymm',       COUNT(*) AS 'total deletions'FROM loggingWHERE log_type = 'delete' AND log_action IN ('delete', 'delete_redir', 'delete_redir2') AND log_namespace = 0GROUP BY LEFT(log_timestamp, 6);​

SQL

Checking query status...