NPP Barnstar winners who have not been reviewing much lately

SQL

SELECT actor_name AS `reviewer`,
      COUNT(DISTINCT(logtemp.log_page)) AS `reviews`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE
        log_timestamp BETWEEN (NOW() - INTERVAL 6 MONTH) AND NOW() and
        log_actor=210623181 AND
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor and actor_name in ('John B123', 'JTtheOG', 'Onel5969', 'Mcampany', 'Mccapra', 'Rosguill', 'DragonflySixtyseven', 'Hughesdarren', 'Pichpich', 'Doomsdayer520', 'Abishe', 'Ymblanter', 'DannyS712 bot III', 'Seacactus 13', 'DGG', 'QatarStarsLeague', 'Scope creep', 'Arthistorian1977', 'Elmidae', 'Vexations', 'Sulfurboy', 'Jmertel23', 'Atlantic306', 'Nnadigoodluck', 'Graeme Bartlett', 'Kj cheetham', 'Ozzie10aaaa', 'Boleyn', 'JeBonSer', 'Meena', 'Buidhe', 'Sagotreespirit', 'JohnThorne', 'Whiteguru', 'Willsome429', 'Polyamorph', 'PKT', 'Cwmhiraeth', 'TheWikiholic', 'Þjarkur', 'Lithopsian', 'North8000', 'ZI Jony', 'Insertcleverphrasehere', 'The9Man', 'Vincelord', 'Usedtobecool', 'Ipigott', 'Joseywales1961', 'Govvy', 'Kingsif', 'Blythwood', 'Darwinek', 'Gazal world', 'Lefcentreright', 'Cassiopeia', 'Elli', 'Meatsgains', 'Barkeep49', 'HitroMilanese', 'Csgir', 'Dl2000', 'SS49', 'Slashme', 'Overthrows', 'Sam-2727', 'Utopes', 'Sadads', 'CAPTAIN RAJU', 'I dream of horses', 'MainlyTwelve', 'MB', 'Girth Summit', 'Lopifalko', 'Florentyna', 'Lord Bolingbroke', 'Ser Amantio di Nicolao', 'Jweiss11', 'Bensci54', 'PK650', '力', 'AleatoryPonderings', 'Eddie891', 'Alucard 16', 'TheAafi', 'Troutfarm27', 'Shellwood', 'Ingratis', 'Alexandermcnabb', 'Dewritech', 'AugusteBlanqui', 'Spicy', 'Dps04', 'Umakant Bhalerao', 'Spiderone', 'Celestinesucess', 'WikiAviator', 'Winner 42', 'Fbdave', 'Red Phoenix')
      GROUP BY reviewer
      ORDER BY reviews DESC;
SQL

Checking query status...
