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
Genericusername57
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT CONCAT('https://www.wikidata.org/wiki/', term_full_entity_id, '?action=history') AS item, term_language, term_text FROM wb_terms WHERE term_type = 'description' AND LENGTH(term_text) > 50000 #AND term_text NOT RLIKE "\p{Han}" #AND term_text IN ( # 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'é', # 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'é', # '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '.', ',', ':', ';', '!', '?', '(', ')', '_', '-', '*', '&', '@', '#', '~', '/', '\\' #);
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...