Untitled query #77279

SQL

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

Checking query status...
