Top new article reviewers (last 24 hours)

SQL

SELECT
    actor.actor_name AS reviewer,
    COUNT(DISTINCT logtemp.log_page) AS total,
    SUM(CASE WHEN logtemp.page_is_redirect = 1 THEN 1 ELSE 0 END) AS redirects,
    SUM(CASE WHEN logtemp.page_is_redirect = 0 THEN 1 ELSE 0 END) AS articles
FROM (
    SELECT
        log_actor,
        log_page,
        page_is_redirect
    FROM logging_userindex
    JOIN page ON page.page_title = logging_userindex.log_title
              AND page.page_namespace = logging_userindex.log_namespace
    WHERE log_timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY)
      AND log_type IN ('patrol', 'pagetriage-curation')
      AND log_action IN ('patrol', 'reviewed')
      AND page.page_namespace = 0
) AS logtemp
JOIN actor ON actor.actor_id = logtemp.log_actor
GROUP BY reviewer
ORDER BY articles DESC
LIMIT 100;
SQL

Checking query status...
