Get all page triage details of a page

SQL

SELECT  actor_name AS `Reviewer`, 
        COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex, `user`

		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN user_groups ON ug_user = user_id
        
/**        WHERE log_timestamp BETWEEN 20180708000000 AND NOW()**/
        WHERE log_timestamp BETWEEN 20220708000000 AND NOW()
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND ug_group = 'patroller'
        AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY Reviewer
ORDER BY `Article Reviews` DESC
limit 20;
SQL

Checking query status...
