Untitled query #66432

SQL

SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS `reviews`
FROM (
  SELECT log_actor, log_page
  FROM logging_userindex
  JOIN page ON page_title = log_title AND page_namespace = log_namespace
  -- date format is YYYYMMDDHHMMSS
  WHERE log_timestamp BETWEEN 20220101000000 AND 20220801000000
  AND log_type = 'patrol'
  AND log_action = 'patrol'
  AND log_namespace = 0
  -- change to 1 instead of 0 to query for redirects, and do the same below
  AND page_is_redirect = 0
  UNION
  SELECT log_actor, log_page
  FROM logging_userindex
  JOIN page ON page_title = log_title AND page_namespace = log_namespace
  WHERE log_timestamp BETWEEN 20220101000000 AND 20220801000000
  AND log_type = 'pagetriage-curation'
  AND log_action = 'reviewed'
  AND log_namespace = 0
  AND page_is_redirect = 0
) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY reviewer
ORDER BY reviews DESC
LIMIT 100;
SQL

Checking query status...
