Edit-Warring Wikidata Bots

SQL

USE wikidatawiki_p;
SELECT * from recentchanges as first_edit
join recentchanges as third_edit ON first_edit.rc_actor = 7
AND first_edit.rc_timestamp > 20200806090830
AND third_edit.rc_actor = first_edit.rc_actor
AND third_edit.rc_timestamp > first_edit.rc_timestamp
AND first_edit.rc_title = third_edit.rc_title 
JOIN recentchanges as second_edit 
ON second_edit.rc_timestamp > first_edit.rc_timestamp 
AND second_edit.rc_timestamp < third_edit.rc_timestamp
AND second_edit.rc_title = first_edit.rc_title  
AND second_edit.rc_actor != first_edit.rc_actor 
limit 50
SQL

Checking query status...
