Fork of
X2 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,
concat("Portal:",log_title) as page,
comment_text
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_type = 'delete'
AND log_action = 'delete'
AND log_namespace = 100
AND comment_text RLIKE '\\bP1\\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.