Untitled query #1276

This query is marked as a draft This query has been published by Jura1.
SQL

# test
use wikidatawiki_p; 
SELECT CONCAT('Q', term_entity_id) AS item, term_text, GROUP_CONCAT( term_language ) As langs, 
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 (
18978288, 19006980, 5795850, 18707653, 19689390, 15130287, 18038709, 3660491, 18177247, 
  19688330, 18524102, 18449855, 5088587, 2963143, 14946485, 18195741, 7601360, 18562424, 
  18342070, 18156204, 17518420, 5209168, 4354045, 1067002, 18227986, 18620267, 16188355, 
  18699277, 5802106, 16275369, 18450086, 16549390, 16275526, 18220772, 18450130, 17766912, 
  18699279, 19689401, 16275583, 17018131, 10479874, 12765136, 18145462, 18145467, 3719512, 
  5346977, 19688400, 18116812, 18324312, 2684485, 5829589, 19688408, 19731088, 10482032, 
  18218731, 15849752, 10482249, 5831468, 18587703, 18131047, 3056634, 1857802, 16323502, 
  3482156, 10492741, 16275742, 16275767, 16275784, 15809351, 9258196, 6596953, 18030007, 
  19688418, 5458054, 15208017, 16275878, 12017837, 19689420, 18195535, 3094170, 3759041, 
  5528781, 9267344, 3761181, 18218247, 16276004, 5584405, 17864520, 16276257, 13584814, 
  16276289, 18611851, 14945139, 18641773, 18111066, 16427546, 18410867, 18038848, 16276743, 
  18176395, 18188038, 18220017, 19411671, 19689445, 18043410, 6978561, 19688618, 16277100, 
  10535639, 11977320, 18177335, 3801794, 3802190, 19278672, 18198822, 19376017, 18171079, 1822320, 16429346, 4295485, 4178117, 18147464, 18218143, 11725845, 16277391, 5932709, 18220098, 18218344, 14436605, 3766002, 18194764, 10541107, 14629919, 16563832, 17374392, 2408413, 18697129, 17854918, 16430008, 18978361, 6377170, 15823286, 10544842, 3195138, 19689457, 19688881, 18584936, 11743623, 17518406, 6434189, 18039564, 19595388, 19597653, 18608330, 3229170, 2755787, 4256413, 19379451, 16420838, 19380171, 18181772, 19347737, 18699291, 18526591, 16278614, 19689479, 
  18176973, 3282050, 12034998, 11766819, 6751262, 16576135, 6762645, 18193752, 
  1532960, 19688703, 18823055, 16279273, 2607462, 6836888, 19381519, 16422423, 2313170, 12796682, 18385152, 18699294, 10586124, 18082046, 3859710, 18978392, 1285335, 9301036, 10594119, 16422886, 1977784, 18642351, 16280131, 18452229, 18199687, 253589, 11795834, 18339805, 19688723, 18699301, 19360717, 4927713, 16420784, 18978403, 19688729, 16423546, 16280473, 8758158, 18060544, 17641352, 16280529, 17770018, 17764440, 11887738, 19594626, 18608522, 18978414, 12045349, 18978415, 19688743, 18986522, 19689528, 19687118, 18520545, 18503079, 7308423, 18385819, 16861467, 
  17561019, 16280912, 18420753, 18038759, 18551845, 2066845, 16281029, 18844258, 16281046, 7397944, 10660337, 18191037, 12050883, 18023649, 17591690, 18157157, 6124292, 18950544, 18608876, 14901750, 16425929, 12672893, 18067255, 3491121, 18609788, 18760994, 16281837, 7674709, 17326500, 18198086, 15111386, 8346272, 16428902, 18028626, 19688778, 3991600, 19688779, 19345740, 18699306, 12059666, 16618163, 16282229, 15829976, 16282244, 9366507, 15732145, 7900718, 13405605, 14438051, 9370421, 17142382, 18571949, 16282503, 18182056, 2689397, 18130793, 19688788, 18180431, 
  18012369, 18699308, 16430484, 16430488, 9383641, 19001706, 17327128, 3894860, 16275103, 5202338, 18670193, 17374327, 362403, 2529610, 1855388, 2672502, 5760091, 
  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.
SQL

Checking query status...
