Filter erroneous edits

SQL

/*
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 count(distinct page_title) from page
join revision_userindex on rev_page = page_id and page_namespace = 0 and page_is_redirect = 1
join actor_revision on actor_id = rev_actor and actor_name = 'NmWTfs85lXusaybq'
SQL

Checking query status...
