Top new article reviewers (last 24 hours)

This query is marked as a draft This query has been published by DreamRimmer.

SQL

SELECT
    actor.actor_name AS reviewer,
    SUM(CASE WHEN logtemp.log_type = 'patrol' THEN 1 ELSE 0 END) AS articles,
    SUM(CASE WHEN logtemp.log_type = 'pagetriage-curation' THEN 1 ELSE 0 END) AS redirects,
    COUNT(*) AS total
FROM (
    SELECT
        log_actor,
        log_type
    FROM logging_userindex
    WHERE log_timestamp >= DATE_SUB(NOW(), INTERVAL 24 Hour)
      AND log_type IN ('patrol', 'pagetriage-curation')
) AS logtemp
JOIN actor ON actor.actor_id = logtemp.log_actor
GROUP BY reviewer
ORDER BY total DESC
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...