ReferenceExpander edits, 2023

Edits in 2023 with summaries containing "ReferenceExpander" (case-sensitive).

July-December 2022 edits in query 72745.  Summary by month in query 72740; compare query 72737.

For [[WP:RAQ#ReferenceExpander]] circa 1 Apr 2023.

SQL

SELECT r1.rev_id,
       r1.rev_timestamp,
       actor_name,
       r1.rev_len - COALESCE(r2.rev_len, 0) AS delta,
       comment_text
FROM revision AS r1
JOIN comment_revision ON comment_id = r1.rev_comment_id
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN revision AS r2 ON r2.rev_id = r1.rev_parent_id
WHERE r1.rev_id IN
(
  SELECT rev_id
  FROM revision
  JOIN comment_revision ON comment_id = rev_comment_id
  WHERE comment_text LIKE '%ReferenceExpander%'
    AND rev_timestamp BETWEEN '2020' AND '2021' -- any range longer than about a year does a full table scan
  UNION
  SELECT rev_id
  FROM revision
  JOIN comment_revision ON comment_id = rev_comment_id
  WHERE comment_text LIKE '%ReferenceExpander%'
    AND rev_timestamp BETWEEN '2021' AND '2022'
  UNION
  SELECT rev_id
  FROM revision
  JOIN comment_revision ON comment_id = rev_comment_id
  WHERE comment_text LIKE '%ReferenceExpander%'
    AND rev_timestamp BETWEEN '2022' AND '2023'
  UNION
  SELECT rev_id
  FROM revision
  JOIN comment_revision ON comment_id = rev_comment_id
  WHERE comment_text LIKE '%ReferenceExpander%'
    AND rev_timestamp >= '2023'
  )
ORDER BY r1.rev_len - COALESCE(r2.rev_len, 0) ASC;

SQL

Checking query status...