SQL
AخA
USE enwiki_p;
SELECT log_id, log_actor, DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp, CONCAT('File:', log_title) AS pagename, comment_text
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
LEFT JOIN actor_logging ON actor_id = log_actor
WHERE log_type = 'delete'
AND log_action = 'delete'
AND log_namespace = 6
AND comment_text LIKE '%fair-use rationale%'
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.