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
use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id), term_text, GROUP_CONCAT( term_language ) from wb_terms WHERE term_entity_type = 'item' AND term_language in ('en','fr','it','de') and term_type = 'label' and term_entity_id IN (1000788, 1001145, 1001175, 1019001, 1019467, 1019952, 1020893, 1022583, 1026719, 102813, 1028709, 1028995, 1030853, 103482, 1036384, 1036388, 1036397, 10422577, 1044192, 1044301, 1044611, 1058604, 1063184, 1063394, 1063414, 1067066, 1068638, 10754, 1077560, 1077683, 1077775, 1077850, 1091886, 1093318, 1096260, 1098255, 1098302, 1103894, 1104106, 1112206, 1115916, 1116427, 1117240, 1125344, 1126053, 1126440, 11264628, 1127103, 1127106, 113165, 113245, 1133251, 1135492, 1136097, 1136208, 1136379, 1140203, 11426224, 11427837, 1144068, 1144075, 1144092, 1147267, 1147388, 1148812, 115490, 115552, 115666, 1156762, 115703, 115721, 115731, 1157351, 115761, 1157948, 115859, 115863, 1158740, 1159068, 115912, 115958, 115971, 115994, 116005, 116030, 116042, 116054, 116143, 116154, 116340, 116350, 116380, 116387, 116438, 1165213, 1165230, 116571, 1165787, 116682, 116754, 116769, 116776, 1167978, 116818, 116860, 116875, 116954, 11697572, 117028, 1170333, 117046, 117185, 117272, 117285, 117304, 1173079, 117331, 117341, 117370, 117380, 117463, 117468, 117558, 11756894, 117584, 117675, 117700, 117706, 117778, 117808, 117814, 117885, 117901, 117932, 117935, 117999, 118041, 118077, 118082, 118163, 118392, 118476, 118506, 1185580, 118617, 118726, 118735, 118746, 118756, 118785, 118877, 118968, 119067, 11910636, 119141, 119330, 119430, 119541, 119601, 119631, 119651, 11979655, 119850, 119860, 119865, 119893, 119952, 120037, 1200492, 120097, 1201339, 120286, 120289, 120295, 12050325, 120529, 120535, 120562, 120568, 120678, 120682, 120717, 120721, 120748, 120754, 120922, 120944, 120977, 120992, 121013, 121066, 121076, 121103, 121113, 121196, 121261, 121271, 121279, 121316, 121328, 121370, 121400, 121450, 121526, 121530, 121563, 121606, 121622, 121669, 121756, 121763, 121772, 121789, 121847, 121875, 121938, 121942, 1220080, 122012, 122017, 122050, 122075, 1220845, 122088, 122091, 122101, 122106, 122111, 122120, 122128, 122134, 122159, 122167, 122218, 122276, 122301, 1223178, 1223182, 122386, 122477, 122509, 122592, 122620, 122663, 122677, 122737, 122839, 122864, 122866, 1229733, 122988, 123004, 123037, 123057, 123115, 1231245, 1232374, 1232540, 1232947, 123325, 123354, 123382, 1234424, 1234426, 123460, 1235115, 123538, 1235484, 1236384, 123654, 1237020, 1237021, 123711, 123718, 1237302, 123732, 123743, 1238038, 1238046, 1238059, 1238063, 123845, 123878, 1239014, 1239439, 123987, 124035, 124063, 124083, 124106, 124135, 124181, 124220, 1242435, 124280, 124287, 124430, 124434, 124442, 124462, 124469, 124480, 124498, 1245425, 124573, 124654, 1246672, 124694, 124702, 124724, 124809, 124820, 124856, 124869, 124872, 124954, 1250039, 1250153, 1250374, 125066, 125111, 125123, 125136, 1252143, 1253754, 1254150, 125501, 125513, 125516, 125524, 125596, 125651, 125675, 125707, 125736, 1258390, 1260097, 1263058, 1264296, 1273348, 1284446, 1284460, 1284469, 128715, 1287311, 1287568, 1287575, 1287603, 1295714, 1296107, 1296856, 1296917, 1299512, 1301003, 1308526, 1310883, 1313462, 1318165, 1327583, 1328955, 1329135, 1329254, 1329357, 1329553, 1329593, 1330517, 1330636, 1330642, 1330644, 1330659, 1331553, 1333744, 1333835, 1333972, 1334103, 1334212, 1336137, 1337941, 1338136, 1338741, 1339173, 1339194, 1340460, 13409234, 1343489, 135115, 13533315, 1353778, 1354967, 1356182, 1356902, 1356964, 1357034, 1357227, 1361019, 1364449, 1364632, 1365810, 1366758, 1369091, 1369408, 1373615, 1374124, 1376130, 1377011, 1380948, 1384719, 1386285, 1388206, 1390286, 1390297, 1390305, 1390328, 139271, 1393008, 1396621, 1402067, 1403981, 1405674, 1405682, 1408955, 1411107, 1411219, 1411241, 1415541, 1417624, 1420398, 1423263, 1423741, 142422, 1428095, 1428333, 1428917, 1434203, 14375790, 1438647, 1439081, 1439351, 14405147, 1441336, 1445547, 1445923, 14476340, 1450841, 1451904, 14530187, 14537009, 1456130, 14566743, 1458208, 1459606, 14627099, 1462921, 14633141, 1468034, 1471368, 1474957, 1478073, 147992, 1480343, 1482890, 1483316, 1484295, 1488722, 14899125, 1490282, 14912667, 14916836, 1492169, 1492591, 1492600, 1494500, 1494540, 1494709, 1496923, 1497659, 1497940, 1500190, 1502710, 1503481, 15068753, 15074505, 15079227, 1510529, 1510592, 1510963, 1511011, 15117164, 15118820, 1512957, 1513953, 1515443, 1515907, 1516860, 1519176, 15199744, 15199751, 15200147, 1520866, 1522261, 1522351, 1523391, 1524135, 1525240, 15257381, 15294526, 1531229, 1533380, 1533827, 1533954, 1534286, 1534848, 153614, 1536193, 15403495, 15409295, 15410577, 1541684, 15427494, 15428166, 15428450, 15428468, 15428505, 15428691, 15429345, 15430828, 15431088, 15431691, 15433272, 15433620, 15434076, 15434219, 15434338, 15436402, 15436429, 15437256, 15437535, 15437622, 15438383, 15440942, 15441398, 15444648, 15445724, 15445937, 15448543, 15448552, 15448998, 15451144, 15451208, 15454138, 1545551, 15455574, 15455988, 15456645, 1547005, 1547596, 15479609, 15479624, 15479926, 15480267, 15484176, 15484822, 15485264, 1550375, 15507915, 1551517, 1553419, 1554674, 1557510, 1557658, 1558131, 1558337, 1558897, 15613356, 15621561, 15621565, 15621771, 15621778, 1562533, 1563002, 15631688, 15663436, 15663442, 15665466, 15665683, 1568108, 156814, 15690946, 1569949, 15706612, 15724644, 15728492, 15729531, 15729986, 15732464, 1575380, 1575564, 1576461, 1576567, 1576862, 1576935, 1577567, 1578229, 1578251, 15784608, 15788297, 15791816, 15792568, 15794132, 15794528, 15804319, 15804581, 15807321, 15808752, 15809822, 15818812, 15819296, 15819322, 15819325, 15821607, 15824645, 15824775, 15825764, 15825885, 15830575, 15834876, 15835971, 15836216, 1583725, 15837608, 1583837, 1583927, 1583999, 1584085, 15841596, 15842782, 15842978, 15843332, 15849757, 15850878, 15850987, 15852438, 15852979, 15855237, 15857455, 15858821, 1587264, 1587314, 1587315, 15873325, 15905573, 15906428, 1591225, 1591957, 1592441, 1593259, 1593269, 1593320, 1593331, 1593343, 1593404, 1594459, 1594461, 1595281, 15956282, 1596237, 15971276, 15977329, 15983671, 16003140, 16007498, 1601650, 16017881, 1602466, 16029071, 16039618, 16061341, 16064320, 16073022, 1609248, 16092676, 1609404, 16101730, 16101751, 16101754, 16101774, 1610442, 16104481, 16104508, 16104568, 16105371, 16106545, 1613612, 16147322, 16148161, 16150184, 1617509, 1617901, 1618096, 16185385, 16199472, 1621217, 16221642, 16222450, 16232854, 16235828, 16237064, 1624518, 16267404, 1627467, 1628110, 16319042, 1632356, 16334540, 1638001, 1642690, 1644086, 1648422, 16500131, 1650253, 16504474, 16508838, 16509200, 1652589, 16527280, 16551252, 16559665, 1656273, 16569473, 165779, 1658841, 1659015, 16598544, 1660296, 1660841, 1661447, 16638947, 16640091, 16644146, 16657126, 16657475, 1666045, 16663453, 16670695, 16680278, 1672854, 1674021, 16747251, 1674891, 1675022, 167592, 1675978, 1676004, 1676052, 1676342, 1678845, 16798647, 1682324, 1682722, 1682742, 1682769, 1682817, 16830856, 16831241, 1683125, 1683134, 16831946, 16832425, 16832465, 1683485, 1683591, 1683706, 1684864, 1685017, 1686526, 1686559, 1687574, 1687770, 1687848, 16880253, 16887870, 16887871, 16887873, 1691299, 1692133, 16928246, 16937564, 16937614, 16937776, 16937782, 16937819, 16977436, 16980201, 1701604, 17041302, 1708069, 1709034, 1710286, 1710740, 1710876, 1711563, 1712110, 1712223, 17124849, 17125636, 17126453, 1718459, 17194420, 17194423, 1719603, 17197972, 1719994, 1721907, 17260522, 1726910, 17280949, 17294341, 1729483, 1730152, 17305213, 17305221, 17305223, 17305227, 17305565, 17305569, 17305574, 17310154, 17327421, 173284, 173286, 1733852, 1734949, 1735254, 17352721, 1736563, 17388976, 1739006, 1740046, 1740710, 17410926, 1741292, 1741514, 1741534, 17425292, 1743702, 17465608, 1747796, 17479610, 17479617, 17488930, 1750389, 17504751, 1751099, 1751154, 17522385, 17525065, 175251, 1754310, 17579870, 17580033, 17619317, 1765747, 1767425, 17736422, 17736475, 1776819, 1789336, 1792255, 1792260, 1793488, 1795561, 1795563, 1795626, 1798692, 1798994, 17992736, 1800293, 1805695, 1805788, 1811261, 18132209, 1818369, 1818830, 1818930, 1819466, 18198693, 1821042, 18221131, 18221163, 18221166, 18221176, 18221351, 1822342, 1825620, 1825648, 1826635, 1827967, 18330717, 18402406, 18402490, 18413891, 18414741, 18516066, 18533927, 18584309, 18641929, 18642533, 18642575, 18683221, 18683222, 18683224, 18683228, 18683229, 18683232, 18683233, 18683240, 18683241, 18683256, 18683267, 18683271, 18683282, 18683285, 18683287, 18683289, 18683291, 18683299, 18683305, 18683309, 18683324, 1871195, 1871198, 1871219, 1871399, 1871423, 1871440, 1872687, 1873547, 1873609, 1873613, 1873636, 1877620, 1879500, 188026, 1880417, 1883088, 1883407, 1885108, 1890319, 1890415, 1890996, 1891361, 1891369, 1891898, 1892517, 1895107, 1898545, 1903120, 1903123, 1908792, 1911189, 1917703, 1918332, 1920191, 1920963, 192108, 1926692, 1934443, 1936294, 193661, 1938283, 1938831, 194028, 1940843, 1941085, 1951410, 1951427, 1956767, 1956826, 1956842, 1957572, 1959331, 1959637, 1963338, 1964468, 1966077, 1966099, 1966801, 1978202, 1986338, 1990247, 1993255, 2001713, 2002211, 2003843, 2003867, 2003908, 2004063, 2018968, 2019898, 2029715, 203422, 2037852, 203816, 2046041, 2046132, 2047594, 2055201, 2056472, 2057097, 2058458, 206328, 2064223, 2064228, 2065784, 2067512, 207150, 207163, 207168, 2073301, 2073377, 2073385, 2073491, 2084478, 2085519, 2092009, 2093027, 2097885, 2099140, 2102572, 2107454, 2115340, 2125668, 2127078, 2127079, 2127385, 2127387, 2128008, 2128119, 2128414, 2128491, 2129538, 2129572, 2129628, 2129764, 213095, 2131215, 2131261, 2135962, 2136596, 2140410, 2151126, 2155003, 215577, 2160181, 2162617, 2163937, 2165163, 2165651, 2165716, 2166020, 217389, 2176337, 2179262, 2202854, 2210308, 2211173, 2216925, 2220945, 2225662, 2230957, 2265240, 2268885, 2271729, 2273002, 2273864, 2277096, 2277576, 2281019, 2281033, 2281881, 2284004, 2288673, 2289915, 231954, 2331061, 2338513, 2338845, 2338880, 2358921, 2360401, 2361608, 2364296, 2364958, 2366572, 2373212, 2374628, 2378464, 2384756, 2386938, 2390244, 2391505, 2407572, 2421744, 2422983, 2430172, 2430737, 2430742, 2433488, 2435342, 2435981, 2440652, 2441965, 2444929, 2450316, 2453544, 2456152, 2456157, 245938, 2461812, 2464663, 2472992, 2475016, 2484971, 2489691, 2491397, 2492178, 2501217, 2501383, 2501456, 2504949, 2508708, 250981, 252190, 2526794, 2529104, 253348, 2535089, 2543185, 2552502, 2553378, 2554133, 2558825, 2558986, 2566153, 2567517, 2576877, 2581357, 2587264, 2589010, 25941, 2595916, 2597705, 2599717, 260700, 2610527, 2617912, 262932, 2635333, 2635528, 2640629, 264354, 2647511, 2650685, 2651103, 2651926, 2653271, 2661025, 2671417, 2672249, 2687410, 271251, 271675, 2721602, 2737466, 274246, 2773421, 2777444, 2800656, 280285, 2824708, 2827018, 283762, 2839350, 2839353, 2839361, 2839364, 2839378, 2846805, 2846981, 2847244, 2847525, 2847563, 2848606, 2850782, 2850944, 2851625, 2853491, 2853541, 2853878, 2853902, 2854160, 2861186, 2866261, 2871609, 287240, 2874838, 2874984, 2878676, 2892232, 2898862, 2899050, 2899362, 2904491, 2907303, 2908057, 2929389, 2929398, 2929405, 2929878, 2936265, 2939877, 2940716, 2941561, 2946986, 2950117, 2956438, 2957902, 2957986, 2957996, 2958007, 2958115, 2958175, 2958271, 2958283, 2958335, 2961079, 2961315, 2961873, 2964659, 2964952, 2964989, 2974207, 2974990, 2975628, 297605, 2976739, 2979330, 2998036, 2998039, 3008912, 3009008, 3010121, 3013572, 3021357, 3021857, 3022843, 3022967, 3023380, 3023434, 3026264, 302873, 3033232, 3035539, 3038127, 3047717, 3051529, 3052925, 305577, 3060255, 3063510, 3063528, 3064400, 3067546, 3069023, 306909, 3078548, 3081181, 3081262, 3082468, 3083509, 3087057, 3089539, 3093496, 3099844, 3100322, 3102053, 3105139, 3105143, 3105543, 3105917, 3111443, 3116303, 3118457, 3118578, 3123229, 3125534, 3126773, 3127066, 3130340, 3130351, 3130361, 3130369, 3132467, 3132553, 3142520, 3147884, 3148029, 3153645, 3155885, 3157004, 3157457, 3157958, 3158054, 3158065, 3162004, 3162005, 3162049, 3163265, 3164721, 3165296, 3165304, 3165305, 3165323, 3165394, 3166022, 3168048, 3168051, 3168098, 3169876, 3169996, 3170007, 3176692, 3178679, 3183189, 3183652, 3183725, 3186121, 3186132, 3186662, 3190063, 3190323, 3190434, 3190995, 3191577, 3191724, 3196076, 3196379, 321627, 321893, 3218949, 3228372, 324611, 3258639, 3258788, 3260277, 3260365, 3260419, 3260578, 3264090, 3265109, 3265131, 3265191, 3265779, 3269822, 3270348, 3270394, 3270576, 3270750, 3270777, 3275803, 327774, 3282092, 3287697, 3288630, 3289232, 3289300, 3291679, 3291715, 3291877, 3291932, 3291972, 3291982, 3292044, 3292130, 3292992, 3292993, 3295266, 3296120, 3296132, 3296300, 3296347, 3299968, 3302780, 3304468, 3307962, 3313711, 3314447, 331510, 3317258, 3326255, 3326256, 3331423, 3331489, 3331561, 3332870, 3335638, 3339963, 3342677, 3344851, 3344865, 3349199, 3349230, 3351905, 335899, 3359234, 3368590, 3372574, 3372614, 3375512, 3382854, 3383288, 3383326, 3383437, 338717, 3387899, 3388374, 3408596, 3414186, 3414917, 3417422, 3418821, 3419213, 3423448, 3425706, 3425718, 3428871, 3430018, 3430436, 343810, 3438280, 3438609, 3438610, 3439907, 3440797, 3442486, 3458904, 3460892, 3460895, 3470038, 3473538, 3476681, 3481336, 3482966, 3486741, 3496638, 3499168, 3501460, 3502211, 3505199, 3506248, 3507424, 3510289, 3524817, 352678, 3528083, 3529578, 355352, 355353, 3560334, 3560444, 3561171, 3567383, 357286, 3574472, 3588901, 359035, 3603877, 3616433, 3629571, 3635294, 3635440, 3635618, 3638023, 3638699, 3638704, 3638719, 3638728, 3638746, 3660686, 3664233, 3664950, 366571, 368915, 3695409, 3704834, 3706130, 3712628, 3712835, 3716769, 3722932, 3722978, 3723780, 3736385, 3742258, 3760190, 3761212, 3761217, 3761869, 3761870, 3764869, 3766136, 3766138, 376619, 3768938, 3769032, 3769317, 3773622, 3775855, 3776391, 3777985, 3777992, 3784791, 3784818, 380587, 3807590, 3813165, 3814069, 3814783, 3814888, 3817031, 3826589, 3830285, 3831566, 3836388, 3837869, 3841086, 3849367, 3850559, 3850567, 3852333, 3853980, 3855122, 3856909, 3869238, 3869902, 3874633, 3875799, 3879523, 3885602, 3888779, 3895855, 389814, 3905145, 3905154, 3905368, 3905384, 390685, 391569, 3926103, 3928919, 3929297, 3935773, 3939577, 3939605, 3941524, 3944436, 3945520, 3948329, 395124, 3958452, 3960033, 3961342, 3979921, 3984326, 398984, 3999918, 4002990, 4008602, 4011209, 4015188, 4015189, 4019189, 4022767, 4022809, 4022888, 4024401, 404839, 4101489, 410286, 4137561, 4205942, 4205943, 420861, 4272778, 429269, 4302711, 431419, 4320807, 432738, 4332701, 433625, 437824, 438362, 4410974, 441867, 446651, 447767, 449338, 452511, 453512, 453596, 453885, 455385, 458498, 458781, 459613, 459750, 460012, 460256, 460656, 460923, 46134, 462797, 464058, 467539, 4684169, 469804, 469873, 471956, 4727598, 472905, 4732959, 4736207, 4768966, 4769187, 477975, 4788148, 484266, 487548, 489348, 4966902, 503925, 5047689, 506256, 509897, 509949, 510640, 511628, 511641, 5134415, 513538, 514427, 5162081, 516706, 5223728, 523676, 5270573, 527904, 5279371, 5280738, 5293785, 529833, 5317739, 532395, 5337980, 5337986, 535997, 536027, 5360414, 5360415, 5361652, 536270, 536548, 536587, 5368103, 537597, 5427644, 5427653, 5427681, 544734, 5460503, 5460984, 5465581, 5475506, 5506644, 550894, 550917, 550954, 550961, 550973, 550976, 5530897, 5558006, 556530, 559389, 5612786, 562327, 564225, 564255, 564394, 564900, 5651271, 566126, 566193, 566797, 566801, 567182, 569569, 5697735, 570189, 577007, 5789796, 584242, 587450, 587493, 5908971, 5951017, 5960655, 598201, 601249, 6068571, 609796, 6120293, 6169181, 6169206, 625682, 632341, 6347450, 636662, 6397955, 6409253, 6410062, 6424385, 6453899, 64583, 6481749, 6483077, 6506707, 6511288, 653409, 6539123, 6539405, 6577763, 658694, 660228, 660246, 662114, 663391, 664087, 665196, 665466, 666558, 667348, 6689629, 669879, 6698972, 669900, 670284, 670420, 6706614, 670924, 671110, 6711170, 671144, 671587, 671973, 672239, 672285, 672297, 673081, 673245, 674938, 675004, 6753061, 675344, 6755325, 675675, 676127, 6762623, 676721, 676782, 677170, 6771885, 677547, 6778722, 678290, 678459, 679092, 6792306, 679318, 679331, 680591, 680606, 681091, 6811236, 681857, 682794, 682816, 682832, 683757, 685627, 686166, 686308, 6871362, 687233, 6873732, 688789, 688954, 689028, 689739, 690198, 690271, 690412, 691081, 691193, 692000, 692061, 692751, 693940, 6948196, 6948202, 6948203, 6959094, 7001671, 7002446, 7024255, 705541, 705679, 71618, 7178834, 7283369, 7288008, 73085, 7330955, 7354103, 7365857, 7368854, 739930, 7416464, 7417383, 7446493, 7446515, 74523, 745666, 745708, 7494100, 7537013, 7616651, 762936, 7629944, 7629947, 76346, 766997, 767775, 767897, 768076, 768805, 77109, 772409, 776342, 7818856, 7839319, 7901128, 790933, 79641, 804679, 804873, 8049941, 8054762, 805815, 805862, 805863, 805864, 805865, 806324, 807094, 809310, 809338, 809340, 809350, 809370, 810017, 810042, 810057, 810599, 812657, 813788, 813790, 813977, 816408, 816775, 816777, 817270, 817330, 817339, 817762, 818397, 818442, 822833, 826509, 827326, 827571, 828100, 830195, 83428, 83768, 856735, 859507, 863091, 879582, 879626, 879729, 880979, 88528, 886392, 89004, 891332, 892504, 898101, 906575, 908590, 915501, 927738, 930341, 931413, 9673513, 980321, 992332 ) 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...