select `Reviewer`, min(`Article Reviews`) as streak

from

(

  SELECT actor_name, MONTH(DATE_ADD('2022-01-01', INTERVAL @rn:=@rn+1 MONTH)) as month from (select @rn:=-1)t, `order` limit 12

) d left outer join ( 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)=2023

          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

) x using actor_name, month

group by `Reviewer`

order by streak desc