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

SQL

SET @page = "2021 Pacific typhoon season";

SELECT
    COUNT(
      	IF (comment_text LIKE "%/* Current storm information */%", 1, NULL)
    ) as `CSI edits`,
    COUNT(
      	IF (LENGTH(comment_text) = 0, 1, NULL)
    ) as `CSI edits`,
    AVG(
      	CAST(r1.rev_len AS SIGNED) - 
      	CAST((
          	SELECT 
	         	r2.rev_len 
	        FROM revision r2
         	WHERE r2.rev_id = r1.rev_parent_id
        ) AS SIGNED)
    ) as `Average edit difference`
FROM revision r1
JOIN `comment` ON rev_comment_id = comment_id
JOIN actor ON rev_actor = actor_id
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...