NPP - Ozzie10aaaa review counts (365 days)

SQL

SET @since = CURDATE() - INTERVAL 365 DAY;
SET @actor_name = 'Ozzie10aaaa';

SELECT
    actor_name, 
    ug_group, 
    n_patrols,
    n_articles,
    n_redirects
FROM actor
JOIN user_groups ON ug_user = actor_user
LEFT JOIN (
    SELECT
        actor_user,
        COUNT(DISTINCT(log_page)) AS n_patrols,
        COUNT(IF(page_is_redirect = 0, 1, NULL)) AS n_articles,
        COUNT(IF(page_is_redirect = 1, 1, NULL)) AS n_redirects
    FROM actor
    JOIN logging_userindex ON log_actor = actor_id
    JOIN page ON page_title = log_title AND page_namespace = log_namespace
    WHERE log_action = 'reviewed' 
    AND log_type = 'pagetriage-curation'
    AND log_timestamp > @since
    AND log_namespace = 0
    GROUP BY actor_user
) nppstats ON actor.actor_user = nppstats.actor_user
WHERE (ug_group = 'patroller' OR ug_group = 'sysop')
AND actor_name = @actor_name
ORDER BY n_patrols DESC;
SQL

Checking query status...
