Josh's reviews in May 2023

SQL

SELECT count(*), actor_name, log_page, page_is_redirect, log_type, log_action
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        JOIN actor on actor_id = log_actor
        WHERE log_timestamp BETWEEN 20230501000000 AND 20230601000000
        and actor_name="Hey man im josh"
        and page_is_redirect=1
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace = 0
group by log_type, log_action;
SQL

Checking query status...
