patrol and curation of userspace

SQL

SELECT actor_name AS `Reviewer`, log_namespace, page_title, log_type,
      COUNT(*) as `Reviews`
      FROM (
        SELECT distinct log_actor, log_page, log_namespace, page_title, log_type
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE log_timestamp BETWEEN 20220101000000 AND 20230101000000
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace in (2,3)
) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY Reviewer, log_type
having `Reviews`>=100
ORDER BY `Reviews` DESC
limit 20;

SELECT log_namespace, page_title, log_type,
      COUNT(*) as `Reviews`
      FROM (
        SELECT distinct log_actor, log_page, log_namespace, page_title, log_type
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE log_timestamp BETWEEN 20220101000000 AND 20230101000000
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace in (2,3)
) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY log_type
ORDER BY `Reviews` DESC;
SQL

Checking query status...
