SET @sql = NULL;

SET @year = 2023;

SELECT

  GROUP_CONCAT(DISTINCT MONTH(log_timestamp)) INTO @sql

FROM

  logging_userindex

  where YEAR(log_timestamp)=@year

  and MONTH(log_timestamp) > 10

  and log_type = "pagetriage-curation";

SET @sql = CONCAT('SELECT actor_name AS `Reviewer`, @sql,

        COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`

        FROM (

          SELECT distinct log_actor, log_page, page_is_redirect, MONTH(log_timestamp) as month

          FROM logging_userindex

          JOIN page ON page_title = log_title AND page_namespace = log_namespace

          WHERE YEAR(log_timestamp)=@year and MONTH(log_timestamp)>10

          AND 

          ((log_type = "patrol"  AND log_action = "patrol") OR

           (log_type = "pagetriage-curation" AND log_action in ("reviewed", "reviewed-article")))

          AND log_namespace = 0

        ) logtemp

        JOIN actor ON actor_id = log_actor

        JOIN user ON actor_user = user_id

        left JOIN ipblocks ON ipb_user = user_id

        where ipb_sitewide IS NULL

        GROUP BY reviewer, month');

PREPARE stmt FROM @sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

​