Query to get streak eligibles for NPP Backlog drive - July 2022

SQL

    SELECT actor_name, week, 
        COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `reviews`
        FROM (
          SELECT distinct log_actor, log_page, page_is_redirect, WEEK(log_timestamp) as Week
          FROM logging_userindex
          JOIN page ON page_title = log_title AND page_namespace = log_namespace
          WHERE log_timestamp BETWEEN 20220703000000 AND 20220801000000
          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 ('Dr vulpes', 'Hughesdarren', 'Rosguill', 'SunDawn', 'Hey man im josh', 'Kj cheetham')
   GROUP BY actor_name, week

SQL

Checking query status...