Find A7 deletions by a certain user in a certain time frame

Fork of Find all deletions by a certain user on a certain date by SoWhy

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

SQL

SELECT log.log_timestamp AS "timestamp", log.log_namespace AS "namespace", log.log_title AS "page", cmt.comment_text AS "comment"
 FROM logging AS log
 LEFT JOIN actor AS act ON log.log_actor = act.actor_id
 LEFT JOIN comment AS cmt ON log.log_comment_id = cmt.comment_id
 WHERE log.log_action = "delete"
 AND act.actor_name = "RHaworth"
AND log.log_timestamp >= 20191201000000
AND log.log_timestamp <= 20191231235959
AND log.log_namespace = 0
AND cmt.comment_text RLIKE "A7"
ORDER BY log.log_timestamp DESC

SQL

Checking query status...