Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Labels in English for items whose names begin with "The"
by
Rex1517liu2368
This query is marked as a draft
This query has been published
by
Rex1517liu2368
.
Labels in English for items whose names begin with "Top"
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT CONCAT('Q', w2.term_entity_id) As item, CONCAT('"', w2.term_text, '"') As descr, GROUP_CONCAT(w1.term_text separator ' *, ') As alias, CURRENT_DATE from wb_terms w2 join wb_terms w1 on w2.term_entity_id = w1.term_entity_id WHERE w2.term_entity_type = 'item' AND w2.term_language = 'en' AND w2.term_type = 'label' # 'description', 'alias' AND w2.term_text LIKE 'Top %' and (w1.term_entity_type = 'item' AND w1.term_language = 'en' AND w1.term_type = 'alias') GROUP BY w2.term_text, w2.term_entity_id
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...