SELECT actor_name AS `reviewer`,

      COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles`,

      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects`,

      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

        WHERE

        ((log_type = 'patrol'  AND log_action = 'patrol') OR

         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))

        AND log_namespace = 0

        AND log_timestamp BETWEEN 20000101000000 AND 20230601000000

      ) logtemp

      JOIN actor ON actor_id = log_actor

      GROUP BY log_actor

      ORDER BY `Redirects` DESC

      LIMIT 20;