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, 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...