Filter erroneous edits

SQL

/*
WITH rc_edits AS (
  SELECT * FROM recentchanges_userindex
  JOIN actor_revision ON actor_id = rc_actor AND actor_name = 'NmWTfs85lXusaybq'
  JOIN page ON rc_cur_id = page_id AND page_namespace = 1
  WHERE rc_timestamp > 20231022154900 AND rc_timestamp < 20231023031100 -- AND rc_namespace = 1
  AND rc_this_oldid = page_latest AND rc_minor = 0
)

select rd0.page_title, rd0.rc_last_oldid from rc_edits rd0
where rd0.rc_namespace = 1 and rd0.page_title in (
  select rc1.page_title from rc_edits rc1
  where rc1.rc_cur_id in (
    select rc2.rc_cur_id from rc_edits rc2
    where rc2.rc_title != 'Talk_pages_with_comments_before_the_first_section'
    group by rc2.rc_cur_id
    having count(rc2.rc_id) > 1
  )
  group by rc1.rc_cur_id
  having group_concat(rc1.rc_title) rlike '(WikiProject|Past_proposed|-importance|-Class|copied_template|paid_contributions)'
)
*/

select actor_name, rc_title from recentchanges_userindex
join actor_revision on actor_id = rc_actor and actor_name != 'NmWTfs85lXusaybq'
where rc_namespace = 1 and rc_this_oldid in (
  SELECT page_latest
  FROM recentchanges_userindex
  JOIN actor_revision ON actor_id = rc_actor AND actor_name = 'NmWTfs85lXusaybq'
  JOIN page ON rc_cur_id = page_id AND page_namespace = 1
  WHERE rc_namespace = 1 AND rc_timestamp > 20231022154900 AND rc_timestamp < 20231023031100
  AND rc_this_oldid != page_latest AND rc_minor = 0
)

/*
SELECT page_title, page_latest
FROM recentchanges_userindex
JOIN actor_revision ON actor_id = rc_actor AND actor_name = 'NmWTfs85lXusaybq'
JOIN page ON rc_cur_id = page_id AND page_namespace = 1
WHERE rc_namespace = 1 AND rc_timestamp > 20231023033300
AND rc_this_oldid = page_latest AND rc_minor = 0
-- GROUP BY rc_cur_id
-- HAVING COUNT(rc_id) = 1
*/
SQL

Checking query status...
