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
Jura1
.
Toggle Highlighting
SQL
# test use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id) AS item, term_text, CONCAT('#{{Q|', term_entity_id, '}}') AS simplelist from wb_terms WHERE term_entity_type = 'item' # 'item' not 'property' and term_type = 'description' # 'label', 'description', 'alias' and term_language in ('en') and term_entity_id IN ( 16278542, 3837941, 1617357, 6698984, 16278608, 3275790, 1885936, 849545, 1933102, 1511080, 2162995, 14437342, 2909086, 16290624, 429025, 11771370, 16279175, 1212740, 1064920, 1931124, 1076681, 3752124, 1759001, 6851268, 3858198, 1936996, 783934, 6873581, 1529838, 1724634, 937447, 1956729, 3335197, 3335513, 262776, 18219737, 1990345, 5801333, 18088488, 226742, 1314360, 2014517, 16511262, 2023693, 18000299, 1951683, 8078884, 15023157, 2036551, 2037285, 15838080, 1158980, 922567, 4925623, 497612, 11813758, 16269170, 10625184, 16423664, 18577853, 1514563, 1489904, 1236883, 4927756, 18638702, 3408597, 1747790, 2127696, 3930939, 656698, 7308931, 10650636, 348946, 2724050, 1094218, 7352154, 1158139, 1069139, 13403839, 18844246, 605821, 4404545, 7403650, 13858350, 2799307, 9073276, 7420128, 4928170, 3954739, 2273214, 12051535, 12000304, 2073362, 1297491, 602977, 1113134, 1241023, 12718828, 10686817, 1417633, 3514140, 9355534, 2415656, 3523520, 16420953, 10697865, 1619766, 2435866, 6147511, 7820080, 9361602, 2143867, 1158289, 10706999, 1465588, 1400282, 7881002, 6157351, 2500881, 7901129, 7385728, 7911208, 16282450, 7928397, 301657 17505763, 607350, 11903501, 2531449, 16282576, 676823, 1655699, 10723748, 10723768, 8062717, 9392040, 3576224 ) GROUP BY term_text
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...