Months where a reviewer crossed 30 reviews after 2023

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 MPGuy2824.

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
         where year(log_timestamp) > 2023
          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;

SQL

Checking query status...