Untitled query #77279

SQL

SELECT DISTINCT pr.user_name
FROM page AS p
JOIN revision AS r ON p.page_id = r.rev_page
JOIN recentchanges AS rc ON rc.rc_title = p.page_title
JOIN user_groups AS ug ON rc.rc_user_text = ug.ug_user
JOIN user AS pr ON rc.rc_user_text = pr.user_id
WHERE rc.rc_timestamp BETWEEN '20231001' AND '20231031'
AND rc.rc_namespace = 0
AND rc.rc_type = 0
AND p.page_id IN (
  SELECT rd.rd_from
  FROM redirect AS rd
  WHERE rd.rd_namespace = 0
  AND rd.rd_title = "Redirect_for_discussion"
)
AND ug.ug_group = 'patroller';
SQL

Checking query status...
