Untitled query #77279

SQL

SELECT
    actor.actor_name AS reviewer,
    COUNT(*) AS total_reviews
FROM (
    SELECT DISTINCT
        log.log_actor,
        page.page_id
    FROM logging_userindex AS log
    JOIN page
        ON log.log_namespace = page.page_namespace
        AND log.log_title = page.page_title
    WHERE log.log_timestamp >= '20231001000000'
      AND log.log_timestamp < '20231101000000'
      AND log.log_type = 'patrol'
) AS patrolled
JOIN actor ON actor.actor_id = patrolled.log_actor
WHERE patrolled.page_id IN (
    SELECT page_id
    FROM templatelinks
    WHERE tl_namespace = 10
      AND tl_title = 'Redirect_for_discussion'
)
GROUP BY reviewer
ORDER BY total_reviews DESC
LIMIT 100;
SQL

Checking query status...
