Fork of
P1 speed deletions
by Maxim
This query is marked as a draft
This query has been published
by Maxim.
SQL
AخA
SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
concat("Portal:",log_title),
comment_text,
actor_name
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
JOIN actor ON actor_id = log_actor
WHERE log_type = 'delete'
AND log_action = 'delete'
AND log_namespace = 100
AND comment_text RLIKE '\\bP2\\b'
ORDER BY log_id DESC;
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.