Lifetime NPP Stats for a single reviewer

SQL

SET @username = 'Hey man im josh'; -- spaces not underscores

-- Reviews
SELECT COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles Reviewed`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects Reviewed`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN actor on log_actor=actor_id
        WHERE actor_name=@username
        AND
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article', 'reviewed-redirect')))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor;

-- Deletion tagging
      SELECT COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles marked for deletion`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects marked for deletion`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN actor on log_actor=actor_id
        WHERE actor_name=@username
        AND log_type = 'pagetriage-curation' AND log_action = 'delete'
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor;
      
-- Maintainence Tagging
/*
      SELECT COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles marked with maintainence tags`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects marked with maintainence tags`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN actor on log_actor=actor_id
        WHERE actor_name=@username
        AND log_type = 'pagetriage-curation' AND log_action = 'tag'
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor;
*/    
-- Unreviews
/*
SELECT COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles unreviewed`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects unreviewed`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN actor on log_actor=actor_id
        WHERE actor_name=@username
        AND log_type = 'pagetriage-curation' AND log_action = 'unreviewed'
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor;
*/
SQL

Checking query status...
