Fork of
F2 speedy deletions
by HouseBlaster
This query is marked as a draft
This query has been published
by Blablubbs.
SQL
AخA
SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
concat('[[User:', REPLACE(log_title, '_', ' '), ']]') as pagename,
comment_text
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
JOIN actor_logging ON actor_id = log_actor
WHERE actor_name = "Fastily"
AND log_type = 'delete'
AND log_action = 'delete'
AND log_namespace = 2
AND page_namespace = 4
AND comment_text RLIKE '\\bU5\\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.