2021 Pacific typhoon season analysis: Specific edit summaries

SQL

SET @page = "2021 Pacific typhoon season";

SELECT
	COUNT(IF(LCASE(CONVERT(`comment_text` USING utf8)) LIKE '%current storm information%', 1, NULL)) as `CSI`,
    COUNT(IF(LCASE(CONVERT(`comment_text` USING utf8)) LIKE '%season effects%', 1, NULL)) as `SE`,
    COUNT(IF(LCASE(CONVERT(`comment_text` USING utf8)) LIKE '%watches and warnings%', 1, NULL)) as `W&W`,
FROM revision r1
JOIN `comment` ON rev_comment_id = comment_id
WHERE 
    rev_page = (SELECT page_id FROM page WHERE page_namespace = 0 AND page_title = REPLACE(@page, " ", "_"))
GROUP BY comment_text

SQL

Checking query status...