to revert a vandal

SQL

USE trwiki_p;
SET @vandal= "37.154.188",
SELECT CONCAT("tr.wikipedia.org/w/index.php?action=edit&undoafter=",
rc.rc_last_oldid,"&undo=",rc.rc_this_oldid,"&curid=",rc.rc_cur_id) as url, rc.rc_namespace, rc.rc_deleted, rc.rc_patrolled,rc.rc_comment
from recentchanges_userindex rc left join recentchanges r2 on r2.rc_last_oldid = rc.rc_this_oldid
where rc.rc_user_text rlike @vandal
and rc.rc_namespace not in (14)
and rc.rc_this_oldid not in (SELECT r2.rc_last_oldid from recentchanges_userindex r2)

limit 10;
SQL

Checking query status...
