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
Titodutta
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT rc_timestamp, CONCAT("Special:Diff/",rc_this_oldid), rc_title, rc_user_text, rc_comment FROM recentchanges WHERE rc_user_text IN ( 'Titodutta' ) # THE FOLLOWING LINES WILL BE UNCOMMENTED AND ALTERED # ONCE THE LABEL-A-THON STARTS #AND rc_timestamp >= 20181106000000 #adjust this list of items as appropriate AND rc_comment REGEXP 'wbset(alias|description|label)-(add|set)...(anp|as|awa|bcc|bgn|bho|bn|bpy|brh|dty|dv|dz|gom|gu|hi|khw|kn|ks|lus|mai|ml|mr|ne|new|or|pa|pi|pnb|ps|rwr|sa|sat|sd|si|skr|ta|tcy|te|ur) ' ORDER BY rc_this_oldid desc;
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...