Portal deletions (last week of May, 2018)

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_namespace = 100
 AND log.log_timestamp < 20180530062642
 AND log.log_timestamp > 20180521062642
 ORDER BY log.log_timestamp DESC
 LIMIT 20

SQL

Checking query status...