edit summaries containing URL in November 2021 onwards

SQL

SELECT actor_name, page_namespace, page_title, rev_timestamp, comment_text
FROM revision
JOIN page ON page_id = rev_page
JOIN comment_revision ON comment_id = rev_comment_id
JOIN actor_revision ON actor_id = rev_actor
WHERE comment_text LIKE '%https://en.wikipedia.org/wiki/American_and_British_English_spelling_differences#/media/File:Defence_Defense_Labour_Labor_British_American_spelling_by_country.svg%'
AND rev_timestamp > '202111';

AخA
 
SELECT actor_name, page_namespace, page_title, rev_timestamp, comment_textFROM revisionJOIN page ON page_id = rev_pageJOIN comment_revision ON comment_id = rev_comment_idJOIN actor_revision ON actor_id = rev_actorWHERE comment_text LIKE '%https://en.wikipedia.org/wiki/American_and_British_English_spelling_differences#/media/File:Defence_Defense_Labour_Labor_British_American_spelling_by_country.svg%'AND rev_timestamp > '202111';

SQL

Checking query status...