/*

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

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

*/