2021 Pacific typhoon season analysis: Zero-diff edits by user

SQL

SET @page = "2021 Pacific typhoon season";

SELECT
    rev_id,
    LAG(rev_id, 1) OVER (ORDER BY rev_id) as "prev_rev_id",
    rev_len,
    (
      	SELECT 
      		rev_len 
      	FROM revision r2 
      	WHERE r2.rev_id = (
        	SELECT 
          		LAG(r1.rev_id, 1) OVER (ORDER BY r1.rev_id) as "target_rev"
          	FROM revision r3
			WHERE r3.rev_id = target_rev
        )
    ) as "prev_rev_len",
    (`rev_len` - "prev_rev_len") as `diff`
FROM revision r1
WHERE 
    rev_page = (SELECT page_id FROM page WHERE page_namespace = 0 AND page_title = REPLACE(@page, " ", "_"))
ORDER BY rev_timestamp

SQL

Checking query status...