Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Bulgu
.
Toggle Highlighting
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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...