Bottom non-admin new page reviewers

SQL

SELECT logtemp.log_user_text AS `reviewer`,
  (
    CASE WHEN logtemp.log_page IS NULL THEN 0
    ELSE COUNT(DISTINCT(logtemp.log_page))
    END
  ) AS `reviews`
FROM (
  SELECT log_user_text, log_page, log_user
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161101000000 AND NOW()
    AND log_type = 'patrol'
    AND log_action = 'patrol'
    AND log_namespace = 0
  UNION
  SELECT log_user_text, log_page, log_user
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161101000000 AND NOW()
    AND log_type = 'pagetriage-curation'
    AND log_action = 'reviewed'
    AND log_namespace = 0
  UNION
  SELECT user_name AS log_user_text, NULL AS log_page, user_id AS log_user
    FROM user_groups
    JOIN user ON user_id = ug_user
    WHERE ug_group = 'patroller'
) logtemp
WHERE NOT EXISTS (
  SELECT 1
  FROM user_groups
  WHERE ug_user = log_user
  AND ug_group = 'sysop'
)
GROUP BY reviewer
ORDER BY reviews ASC;
SQL

Checking query status...
