NPP pages reviewed daily

SQL

select review_date as date,
      COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects`
from (
	SELECT distinct page_id,
      concat(left(log_timestamp, 4), "-", right(left(log_timestamp, 6), 2), "-", right(left(log_timestamp, 8), 2)) as review_date,
      page_is_redirect
    FROM logging_userindex
	JOIN page
  		ON page_title = log_title AND page_namespace = log_namespace
    WHERE log_timestamp >= 20210101000000
    	AND 
        ((log_type = 'patrol' AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace=0
) logtemp
group by review_date;
SQL

Checking query status...
