Storm path color migration

Tracking migration of {{Storm path}} templates across Wikipedia to the new color scheme. Only checks articles and drafts.

SQL

SET @TOTAL = (
    SELECT COUNT(*)
	FROM templatelinks
	LEFT JOIN linktarget ON tl_target_id = lt_id
	WHERE tl_target_id IN (
  			(SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Storm_path")
    	) AND (tl_from_namespace = 0 OR tl_from_namespace = 118)
);

SET @OLD = (
  	SELECT COUNT(*)
	FROM categorylinks
  	JOIN page ON page_id = cl_from
	WHERE cl_to = "Pages_using_obsolete_storm_path_colors"
  		AND (page_namespace = 0 OR page_namespace = 118)
);

SELECT 
	@TOTAL AS "Total",
    @OLD AS "Old colors",
    (@TOTAL - @OLD) AS "New colors",
    CONCAT((@TOTAL - @OLD)/@TOTAL * 100, "%") AS "Migration progress";

SQL

Checking query status...