Deleted pages by deletion reason ptwiki - 2020

Fork of Deleted pages by deletion reason ptwiki - 2020 by Halfak (WMF)

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

SQL

USE ptwiki_p;
SELECT
  SUM(comment_text REGEXP "WP:ER#ER[0-9]+\\|") as speedy_deleted_articles,
  SUM(comment_text REGEXP "WP:ER#ER20\\|") as unsuitable_articles,
  SUM(comment_text REGEXP "WP:ER#ER6\\|" OR comment_text REGEXP "Spam / propaganda") as spam_articles,
  COUNT(*) as deleted_articles
FROM archive 
LEFT JOIN logging speedy_delete ON
  log_namespace = ar_namespace AND
  log_title = ar_title AND
  log_type = "delete" AND
  log_action = "delete" AND
  log_timestamp > ar_timestamp 
LEFT JOIN comment ON
  log_comment_id = comment_id
WHERE
  ar_timestamp BETWEEN "20190320" AND "20200320" AND
  log_timestamp BETWEEN "20190320" AND "20200320" AND
  ar_parent_id = 0 AND
  ar_namespace = 0;

SQL

Checking query status...