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 ( 2958359, 264002, 1068568, 1071401, 2087646, 1084384, 1091393, 16275220, 16747223, 17436400, 5788600, 3012072, 3012245, 901293, 5212368, 18375359, 265867, 505908, 651493, 1186839, 3705926, 1207216, 3579048, 5807533, 1235797, 16275555, 987115, 18810470, 1265844, 17018121, 1235086, 1267639, 2660560, 5337600, 1287300, 1295158, 1295174, 5347966, 988799, 1328791, 5361701, 6174228, 18614934, 1174817, 5368618, 1334508, 1337676, 541194, 1338717, 17993204, 3056628, 639748, 744012, 187309, 1381706, 4567129, 15731812, 5853744, 9258184, 5856769, 1400798, 2435284, 18624111, 574510, 2268455, 4925932, 1276776, 17485232, 1488403, 1490726, 1496534, 1417358, 1586600, 1297743, 5557943, 15812407, 1537844, 2549909, 11973868, 3126650, 9286083, 10517284, 2021163, 5663963, 16276544, 1035165, 16276646, 1158570, 1618068, 13728754, 16276979, 16277034, 16831923, 655722, 1546248, 3022128, 11712498, 1663269, 1395016, 3798879, 3151388, 1530399, 1673339, 18180635, 11286521, 3446260, 3157852, 761570, 16277309, 1665973, 2438057, 6169987, 5929318, 2227398, 336878, 588700, 2402968, 16277412, 3284319, 1708613, 6303198, 1265453, 1711638, 15731620, 2367525, 1102114, 11166789, 1305584, 692575, 15731850, 1561114, 10544591, 2645657, 1738757, 16832407, 5423162, 1367830, 1784279, 1429894, 3199192, 1608176, 11982930, 1800705, 2028062, 1607500, 1865968, 1111810, 18610169, 1403590, 4267021 ) 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...