3 specific swears in article edit summaries, October 2022

SQL

WITH swears AS (SELECT 'fuck off' AS swear UNION SELECT 'cunt' UNION SELECT 'fuckwit')
SELECT swear,
       CONCAT('[[Special:Diff/', rev_id, ']]') AS diff,
       page_title,
       comment_text
FROM revision
JOIN page ON page_id = rev_page
JOIN comment_revision ON comment_id = rev_comment_id
JOIN swears ON comment_text RLIKE CONCAT('(?i)', swear)
WHERE page_namespace = 0
  AND rev_timestamp BETWEEN '202210' AND '202211';

AخA
 
WITH swears AS (SELECT 'fuck off' AS swear UNION SELECT 'cunt' UNION SELECT 'fuckwit')SELECT swear,       CONCAT('[[Special:Diff/', rev_id, ']]') AS diff,       page_title,       comment_textFROM revisionJOIN page ON page_id = rev_pageJOIN comment_revision ON comment_id = rev_comment_idJOIN swears ON comment_text RLIKE CONCAT('(?i)', swear)WHERE page_namespace = 0  AND rev_timestamp BETWEEN '202210' AND '202211';

SQL

Checking query status...