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;