Months where a reviewer crossed 30 reviews

Fork of Months where a reviewer crossed 30 reviews (after 2023) by MPGuy2824

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

SQL

SELECT actor_name AS `Reviewer`, year, month, count(*) as reviews
FROM (
    SELECT distinct log_actor, log_page, page_is_redirect, MONTH(log_timestamp) as month, YEAR(log_timestamp) as year
    FROM logging_userindex
    JOIN page ON page_title = log_title AND page_namespace = log_namespace
    AND 
    ((log_type = "patrol"  AND log_action = "patrol") OR
    (log_type = "pagetriage-curation" AND log_action in ("reviewed", "reviewed-article")))
    AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor
JOIN user ON actor_user = user_id
and logtemp.page_is_redirect = 0
GROUP BY reviewer, year, month
HAVING reviews >= 30
LIMIT 100;

SQL

Checking query status...