Filter erroneous edits

SQL

SELECT count(page_title)
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
GROUP BY rc_title
HAVING COUNT(rc_id) = 1

/*
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_title
-- HAVING COUNT(rc_id) = 1
*/
SQL

Checking query status...
