2021 Pacific typhoon season analysis: Edit size difference

Part of [[w:en:User:Chlod/Analysis/2021 Pacific typhoon season]]. This query is a general byte size calculator in order to get the byte size changes in a CSV format.

SQL

SET @page = "2021 Pacific typhoon season";

SELECT
    DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H:%i:%s") as `timestamp`,
    (
      	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...