Fork of
P1 speedy deletions
by Trialpears
This query is marked as a draft
This query has been published
by Trialpears.
SQL
AخA
SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
log_title as page,
comment_text,
actor_name
FROM logging
JOIN actor ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_type = 'delete'
AND log_action = 'delete'
AND comment_text RLIKE '\\bG9\\b'
ORDER BY log_id DESC
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.