ReferenceExpander edits, 2020/5/13-2022/6/30 & 2023/4/1-

Edits in the main namespace either between 2020-5-13 and 2022-6-30 inclusive, or after 2023-4-1, with any of the edit summaries ever used by [[User:BrandonXLF/ReferenceExpander.js]].

This obsolesces query 75208, which has no results that are not also here.

For [[WP:RAQ#ReferenceExpander QueryReduxer]] circa 14 July 2023.

SQL

SELECT r1.rev_id,
       r1.rev_timestamp,
       actor_name,
       page_namespace, page_title,
       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
JOIN page ON page_id = r1.rev_page
LEFT JOIN revision AS r2 ON r2.rev_id = r1.rev_parent_id
WHERE comment_text IN ('Expanding bare references.',
                       'Expanding bare references ([[User:BrandonXLF/ReferenceExpander|ReferenceExpander]]).',
                       'Expanding bare references using [[User:BrandonXLF/ReferenceExpander|ReferenceExpander]]',
                       'Expanding bare references using [[w:User:BrandonXLF/ReferenceExpander|ReferenceExpander]]',
                       'Expanding bare references using [[en:w:User:BrandonXLF/ReferenceExpander|ReferenceExpander]]')
  AND (r1.rev_timestamp BETWEEN '20200513' AND '20220631'
       OR r1.rev_timestamp >= '20230401')
  AND page_namespace = 0
ORDER BY r1.rev_id ASC;

SQL

Checking query status...