Edit-Warring Wikidata Bots

SQL

USE wikidatawiki_p;
SELECT * from recentchanges as first_edit
join recentchanges as third_edit ON first_edit.rc_title = third_edit.rc_title 
AND first_edit.rc_timestamp  < third_edit.rc_timestamp  AND first_edit.rc_actor = third_edit.rc_actor 
JOIN recentchanges as second_edit 
ON second_edit.rc_title = first_edit.rc_title AND second_edit.rc_timestamp > first_edit.rc_timestamp 
AND second_edit.rc_timestamp < third_edit.rc_timestamp
AND second_edit.rc_actor != first_edit.rc_actor WHERE first_edit.rc_bot = 1 AND second_edit.rc_bot = 0 
AND first_edit.rc_timestamp > 20200804000000 
limit 50
SQL

Checking query status...
