Editors selected forums 2020 through 2023

SQL

WITH dr_edits AS (SELECT actor_name, actor_id, actor_user, COUNT(*) AS dr_edit_count
                  FROM page
                  JOIN revision ON page_id = rev_page
                  JOIN actor ON actor_id = rev_actor
                  WHERE page_namespace = 4
                  AND page_is_redirect = 0
                  AND page_title LIKE "Deletion_review/Log/202%"
                  GROUP BY actor_id),

mr_edits AS (SELECT actor_name, actor_id, actor_user, COUNT(*) AS mr_edit_count
             FROM page
             JOIN revision ON page_id = rev_page
             JOIN actor ON actor_id = rev_actor
             WHERE page_namespace = 4
             AND page_is_redirect = 0
             AND page_title LIKE "Move_review/Log/202%"
             GROUP BY actor_id),
             
an_edits AS (SELECT actor_name, actor_id, actor_user, COUNT(*) AS an_edit_count
             FROM page
             JOIN revision ON page_id = rev_page
             JOIN actor ON actor_id = rev_actor
             WHERE page_namespace = 4
             AND page_is_redirect = 0
             AND page_title = "Administrators'_noticeboard"
             AND rev_timestamp > 20200000000000
             GROUP BY actor_id),
             
vpr_edits AS (SELECT actor_name, actor_id, actor_user, COUNT(*) AS vpr_edit_count
              FROM page
              JOIN revision ON page_id = rev_page
              JOIN actor ON actor_id = rev_actor
              WHERE page_namespace = 4
              AND page_is_redirect = 0
              AND page_title = "Village_pump_(proposals)"
              AND rev_timestamp > 20200000000000
              GROUP BY actor_id),

afd_edits AS (SELECT actor_name, actor_id, actor_user, COUNT(*) AS afd_edit_count
              FROM page
              JOIN revision ON page_id = rev_page
              JOIN actor ON actor_id = rev_actor
              WHERE page_namespace = 4
              AND page_is_redirect = 0
              AND page_title LIKE "Articles_for_deletion/Log/202%"
              GROUP BY actor_id)
              
SELECT DISTINCT(actors.actor_name), dr_edit_count, mr_edit_count, an_edit_count, vpr_edit_count, afd_edit_count
FROM (
  SELECT actor_name, actor_user, actor_id FROM dr_edits
  UNION 
  SELECT actor_name, actor_user, actor_id FROM mr_edits
  UNION
  SELECT actor_name, actor_user, actor_id FROM an_edits
  UNION
  SELECT actor_name, actor_user, actor_id FROM vpr_edits
  UNION
  SELECT actor_name, actor_user, actor_id FROM afd_edits
) AS actors
LEFT OUTER JOIN dr_edits ON actors.actor_id = dr_edits.actor_id
LEFT OUTER JOIN mr_edits ON actors.actor_id = mr_edits.actor_id
LEFT OUTER JOIN an_edits ON actors.actor_id = an_edits.actor_id
LEFT OUTER JOIN vpr_edits ON actors.actor_id = vpr_edits.actor_id
LEFT OUTER JOIN afd_edits ON actors.actor_id = afd_edits.actor_id
JOIN user_groups ON actors.actor_user = ug_user
WHERE ug_group NOT LIKE "%bot%"
SQL

Checking query status...
