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.actor_id = RCa.actor_id
 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.old_len > 10000
 AND RCd.new_len < 1000
 AND RCd.old_len > BETWEEN RCa.rc_new_len - 100 AND RCa.rc_new_len + 100
AND RCa.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 */
JOIN actor ON actor_id = RCa.actor_id
LIMIT 10;

SQL

Checking query status...