Possible cut-paste moves

Pairs of edits (same actor, nearby timestamp) in which one creates a substantial mainspace page (or expands a small one) and the other removes text from a similarly sized other page leaving it small

SQL

SELECT RCa.rc_timestamp, actor_name, RCa.rc_title, RCd.rc_namespace, RCd.rc_title
FROM recentchanges RCa
JOIN recentchanges_userindex RCd
 ON RCd.rc_actor = RCa.rc_actor
 AND RCd.rc_timestamp BETWEEN RCa.rc_timestamp - 1000 AND RCa.rc_timestamp + 1000 /* ±10 minutes, or when the hour ticks over */
 AND RCd.rc_type = 0
 AND RCd.rc_namespace IN (0, 2, 118) /* Main, User:, Draft: */
 AND RCd.rc_old_len > 10000
 AND RCd.rc_new_len < 1000
 AND RCd.rc_old_len BETWEEN RCa.rc_new_len - 100 AND RCa.rc_new_len + 100
JOIN actor ON actor_id = RCa.rc_actor
WHERE RCa.rc_timestamp < "20220826170000"
AND RCa.rc_new_len > 10000 /* New text is long */
AND ((RCa.rc_type = 0 AND RCa.rc_old_len < 1000) OR RCa.rc_type = 1) /* Old text was short, or new page */
LIMIT 10;

SQL

Checking query status...