NPP - Top redirect reviewers all time (with block status)

SQL

SELECT log_action, COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`,
      SUM(IF(logtemp.page_is_redirect = 1, 0.25, 1)) as `Weighted Total`
      FROM (
        SELECT distinct log_actor, log_action, 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 720 HOUR) 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
      group by log_action;
SQL

Checking query status...
