Portal deletions (last week of May, 2018)

Fork of Portal deletions (last week of May, 2018) by Amorymeltzer

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

SQL

SELECT log.log_timestamp AS `time`, user_name AS `user`, log.log_namespace AS `Namespace`, log.log_title AS `page`
 FROM logging AS log 
 LEFT JOIN user ON log.log_user = user_id
 WHERE log.log_type = 'delete'
 AND log.log_comment NOT RLIKE "RD1"
 AND log.log_comment NOT RLIKE "RD2"
 AND log.log_comment NOT RLIKE "RD3"
 AND log.log_comment NOT RLIKE "RD4"
 AND log.log_comment NOT RLIKE "RD5"
 AND log.log_comment NOT RLIKE "RD6"
 AND log.log_namespace = 100
 AND log.log_timestamp < 20180530062642
 ORDER BY log.log_timestamp DESC

SQL

Checking query status...