Replicas browser and optimizer
All speedy deleted articles in 2017
This query is marked as a draft
This query has been published
This query attempts to list all deletions of pages in the Draft: namespace on en-wiki since 1 January 2018 that were deleted under the speedy deletion criterion G13 and display time, deleting admin, page title and deletion reason
SELECT log.log_timestamp AS `time`, user_name AS `user`, log.log_title AS `page`, log.log_comment AS `comment` FROM logging AS log LEFT JOIN user ON log.log_user = user_id WHERE log.log_type = 'delete' AND log.log_comment RLIKE "G13" AND log.log_timestamp > 20171231235959 AND log.log_namespace = 118 ORDER BY log.log_timestamp DESC
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