- Quarry

SQL

Select * from (
(
  SELECT COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles (this year)`
      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_actor=210623181
		and year(log_timestamp)=2024
		AND
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article')))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor
  ) as c join ( 
  -- Redirects this year
  SELECT COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects (this year)`
      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_actor=210623181
		and year(log_timestamp)=2024
		AND
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-redirect')))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor
  ) as d
)
SQL

Checking query status...
