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";