List of page deletions

SQL

SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
       concat('[[Draft:', REPLACE(log_title, '_', ' '), ']]') as pagename,
       comment_text
FROM logging_userindex
JOIN comment_logging ON comment_id = log_comment_id
JOIN actor_logging ON actor_id = log_actor
WHERE actor_name = "Liz"
  AND log_type = 'delete'
  AND log_action = 'delete'
  AND log_namespace = 2
  AND comment_text RLIKE '\\bG13\\b'
ORDER BY log_id DESC

AخA
 
SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,       concat('[[Draft:', REPLACE(log_title, '_', ' '), ']]') as pagename,       comment_textFROM logging_userindexJOIN comment_logging ON comment_id = log_comment_idJOIN actor_logging ON actor_id = log_actorWHERE actor_name = "Liz"  AND log_type = 'delete'  AND log_action = 'delete'  AND log_namespace = 2  AND comment_text RLIKE '\\bG13\\b'ORDER BY log_id DESC

SQL

Checking query status...