Possibly revdelable log summaries

This query was used to find deletion summaries on en.wikibooks.org that both indicated that the reason for deletion was that the page violated copyright, and that included an excerpt of the page content. The query no longer returns anything, since all of the summaries have been redacted.

SQL

SELECT comment.comment_text, log.log_id
FROM comment
RIGHT JOIN logging AS log ON log.log_comment_id = comment.comment_id
WHERE comment.comment_text LIKE "Use of [[WB:COPYVIO|copyrighted work without permission]]. Please read [[Foundation:Terms of Use|Terms of Use]]: content was%"
AND log.log_type = "delete";

​x
 
SELECT comment.comment_text, log.log_idFROM commentRIGHT JOIN logging AS log ON log.log_comment_id = comment.comment_idWHERE comment.comment_text LIKE "Use of [[WB:COPYVIO|copyrighted work without permission]]. Please read [[Foundation:Terms of Use|Terms of Use]]: content was%"AND log.log_type = "delete";​

SQL

Checking query status...