Monthly streak for NPP reviewers (2023)

SQL

SET @sql = NULL;
SET @year = 2023;
SELECT
  GROUP_CONCAT(DISTINCT MONTH(log_timestamp)) INTO @sql
FROM
  logging_userindex
  where YEAR(log_timestamp)=@year;
/*
SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'max(case when exam = ''',
      exam,
      ''' then field_value end) ',
      field_key
    )
  ) INTO @sql
FROM
  Meeting;
SET @sql = CONCAT('SELECT actor_name AS `Reviewer`, month,
        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
                  limit 10');
                 
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
*/
SQL

Checking query status...
