SQL
x
SELECT 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
/*
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
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.