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 * from rc_edits rc1
where rc1.rc_cur_id in (
  select rc2.rc_cur_id from rc_edits rc2
  where rc_title != 'Talk_pages_with_comments_before_the_first_section'
  group by rc2.rc_cur_id
  having count(rc2.rc_id) > 1
)
limit 100

/*
select actor_name, rc_title from recentchanges_userindex
join actor_revision on actor_id = rc_actor
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...
