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_type = 'label' and term_entity_id IN ( 10002612, 10002665, 10002722, 10002783, 10002886, 10002895, 10002973, 10003041, 10003081, 10003116, 10003165, 10003178, 10003261, 10003340, 10003405, 10003438, 10003482, 10003525, 10003586, 10003699, 10003728, 10003768, 10003793, 10195746, 10195762, 10195773, 10195813, 10195858, 10195911, 10195924, 10195933, 10208594, 10208708, 10208749, 10208801, 10209039, 10209049, 10209064, 10209076, 10209105, 10209171, 10209189, 10209200, 10209248, 10209316, 10209330, 10209375, 10209394, 10209411, 10209436, 10209472, 10209483, 10209507, 10209520, 10209568, 10209596, 10209640, 10209653, 10209694, 10209731, 10209744, 10209765, 10209771, 10209796, 10209821, 10209834, 10209893, 10209918, 10209933, 10209965, 10209980, 10209998, 10210148, 10210159, 10210187, 10210214, 10210230, 10210255, 10210303, 10210322, 10210337, 10210355, 10210405, 10210489, 10210520, 10210577, 10210634, 10210644, 10210664, 10210679, 10210708, 10210751, 10210827, 10210848, 10210868, 10210881, 10210892, 10211049, 10211078, 10211090, 10211103, 10211129, 10211157, 10211179, 10211194, 10211209, 10211225, 10211232, 10211288, 10211305, 10211344, 10211358, 10211405, 10211469, 10211478, 10211533, 10211562, 10211677, 10211686, 10211715, 10211726, 10211738, 10211758, 10211772, 10211830, 10211870, 10211886, 10211907, 10211942, 10212020, 10212034, 10212042, 10212083, 10212096, 10212116, 10212166, 10212179, 10212193, 10212216, 10212237, 10212252, 10212268, 10212289, 10212303, 10212349, 10212378, 10212411, 10212462, 10212477, 10212557, 10212562, 10212598, 10212609, 10212625, 10212641, 10212678, 10212687, 10212718, 10212746, 10212770, 10212794, 10212824, 10212837, 10212853, 10212910, 10212934, 10212984, 10212996, 10213074, 10213165, 10213232, 10213262, 10213330, 10213351, 10213369, 10213413, 10213424, 10213435, 10213464, 10213530, 10213548, 10213573, 10213588, 10213605, 10213614, 10213630, 10213703, 10213715, 10213726, 10213736, 10213753, 10213826, 10213892, 10213918, 10213935, 10213963, 10213977, 10213994, 10214012, 10214036, 10214052, 10214106, 10214125, 10214150, 10214167, 10214180, 10214244, 10214283, 10214314, 10214331, 10214372, 10214405, 10214415, 10214469, 10214493, 10214500, 10214524, 10214577, 10214607, 10214687, 10214707, 10214723, 10214746, 10214762, 10214785, 10214831, 10214844, 10214863, 10214937, 10215002, 10215068, 10215085, 10215112, 10215155, 10215188, 10215206, 10215264, 10215320, 10215331, 10215359, 10215427, 10215473, 10215487, 10215519, 10215532, 10215573, 10215587, 10215596, 10215617, 10215633, 10215651, 10215708, 10215727, 10215767, 10215787, 10215817, 10215834, 10215852, 10215921, 10215941, 10215958, 10215979, 10215990, 10216023, 10216045, 10216062, 10216072, 10216244, 10216340, 10216392, 10216408, 10216422, 10216441, 10216481, 10216515, 10216528, 10216588, 10216626, 10216659, 10216726, 10216749, 10216886, 10216921, 10216947, 10216968, 10216978, 10217013, 10217029, 10217054, 10217067, 10217082, 10217141, 10217159, 10217212, 10217247, 10217271, 10217284, 10217309, 10217323, 10217346, 10217378, 10217393, 10217413, 10217427, 10217437, 10217470, 10217489, 10217506, 10217607, 10217625, 10217648, 10217698, 10217702, 10217768, 10217840, 10217911, 10217930, 10217962, 10218013, 10218061, 10218078, 10218142, 10218288, 10218308, 10218360, 10218395, 10218409, 10218447, 10218488, 10218508, 10218543, 10218567, 10218599, 10218614, 10218621, 10218710, 10218738, 10218768, 10218821, 10218836, 10218867, 10218879, 10218901, 10218915, 10218957, 10219017, 10219040, 10219057, 10219105, 10219166, 10219224, 10219271, 10219312, 10219323, 10219353, 10219388, 10219405, 10219425, 10219456, 10219485, 10219524, 10219536, 10219558, 10219576, 10219605, 10219619, 10219663, 10219683, 10219727, 10219757, 10219772, 10219805, 10219816, 10219908, 10219936, 10219950, 10220002, 10220057, 10220090, 10220151, 10220170, 10220189, 10220206, 10220251, 10220322, 10220334, 10220345, 10220359, 10220377, 10220409, 10220420, 10220457, 10220467, 10220482, 10220512, 10220545, 10220549, 10220573, 10220599, 10220617, 10220664, 10220710, 10220749, 10748990, 10755291, 10763568, 10787312, 11827343, 13262406, 13262407, 13262409, 13262411, 13262416, 13319710, 13319711, 13323654, 13323655, 13323657, 13323660, 13323662, 13323663, 14325955, 14907196, 15120845, 15146142, 15148024, 15181198, 15257519, 15257520, 15257522, 15257527, 15257528, 15257529, 15257530, 15257532, 15257533, 15327853, 15327861, 15327869, 15403802, 15403804, 15922892, 15922894, 15922896, 15922933, 16270452, 16325774, 16394910, 16394912, 16394944, 16500706, 16500707, 16520882, 16779780, 16779785, 16779792, 16779797, 16779804, 16779811, 16779815, 16779828, 16779843, 16779850, 16779857, 16779860, 16779868, 16779873, 16779892, 16779915, 16779923, 16779930, 16779939, 16779946, 16779958, 16816804, 16816809, 16816813, 16816817, 16895286, 16895968, 16897905, 16914295, 16937516, 16938158, 17105442, 17105576, 17106054, 17106059, 17162884, 17162927, 17163032, 17163072, 17163073, 17163184, 17163186, 17163189, 17165789, 17165790, 17165791, 17198513, 17273434, 17273484, 17273573, 17273577, 17273587, 17273593, 17273594, 17273595, 17273603, 17273604, 17273605, 17273614, 17273634, 17273635, 17273636, 17273637, 17273656, 17273657, 17274936, 17303580, 17303594, 17303596, 17303630, 17303667, 17303671, 17303679, 17303683, 17303684, 17303685, 17303686, 17303716, 17303720, 17303746, 17303747, 17303756, 17303773, 17303779, 17303782, 17303784, 17303785, 17339904, 17424409, 17444207, 17477051, 18012885, 18014542, 18090025, 18090027, 18329601, 18329641, 18403386, 18403387, 18403388, 18403523, 18403525, 18524997, 18524998, 18525009, 18635456, 18635457, 18656608, 18656610, 18656611, 18656612, 18656613, 18656615, 18656616, 18656617, 18701281, 18921266, 19123610, 19123689, 19359084, 19359085, 19359086, 19359087, 19359089, 19359090, 19359091, 19359092, 19359093, 19359094, 19359095, 19359096, 19359097, 19359099, 19359100, 19359101, 19359103, 19359104, 19359105, 19359106, 19359107, 19359109, 19359110, 19359111, 19359112, 19359113, 19359116, 19359119, 19359120, 19359219, 19359220, 19359221, 19360933, 19363023, 19363024, 19363028, 19363029, 19363030, 19363031, 19363032, 19363034, 19363038, 19363039, 19363040, 19363041, 19363042, 19363043, 19363044, 19363045, 19363046, 19363047, 19363048, 19363049, 19363050, 19363051, 19363052, 19363054, 19363055, 19363056, 19363057, 19363058, 19363059, 19363060, 19363061, 19363062, 19363063, 19363064, 19363065, 19363066, 19363067, 19363068, 19363069, 19363070, 19363071, 19363072, 19363073, 19363074, 19363075, 19363076, 19363077, 19363078, 19363079, 19363080, 19363082, 19363084, 19363085, 19363087, 19363088, 19363089, 19363090, 19363091, 19363092, 19363093, 19363095, 19363096, 19363097, 19363098, 19363099, 19363100, 19363101, 19363102, 19363103, 19363104, 19363105, 19363106, 19363107, 19363108, 19363109, 19363110, 19363111, 19363112, 19363114, 19363115, 19363116, 19363117, 19363118, 19363119, 19363122, 19363127, 19363128, 19363129, 19363130, 19363131, 19363132, 19363133, 19363134, 19363135, 19363136, 19363137, 19363140, 19363142, 19363143, 19363144, 19363145, 19363146, 19363147, 19363148, 19363149, 19363150, 19363151, 19363152, 19363153, 19363154, 19363155, 19363156, 19363157, 19363158, 19363159, 19363161, 19363162, 19363164, 19363165, 19363166, 19363167, 19363168, 19363169, 19363171, 19363172, 19363173, 19363174, 19363175, 19363176, 19363177, 19363178, 19363179, 19363180, 19363181, 19363182, 6296741, 6296742, 6296751, 6296753, 6296755, 6296760, 6296762, 6296763, 6296766, 6296767, 6296770, 6296771, 6296774, 6296776, 6296778, 6402900, 6418186, 6418207, 6418799, 6420454, 6420982, 6427956, 6428001, 6429943, 6431683, 6434239, 6449692, 6466974, 6468971, 6469667, 6528294, 6528301, 6528318, 6528327, 6528331, 6528350, 6528376, 6528447, 6547989, 6548000, 6612898, 6764426, 6769919, 6834520, 6834760, 6839377, 6839391, 6839442, 6839466, 6839556, 6839591, 6839665, 6839683, 6839962, 6931421, 6986499, 6989145, 6991445, 7013724, 7140299, 7140300, 7140301, 7140308, 7140309, 7140310, 7140311, 7140313, 7140314, 7140335, 7140336, 7140344, 7140631, 7140636, 7140641, 7140642, 7140653, 7140661, 7140662, 7140670, 7140672, 7140678, 7140679, 7140680, 7140685, 7140695, 7140696, 7140698, 7140715, 7140725, 7140728, 7140734, 7140738, 7140743, 7140744, 7140749, 7140763, 7140769, 7140771, 7140779, 7140799, 7140804, 7140807, 7140810, 7140812, 7140822, 7140824, 7140831, 7140842, 7140843, 7140858, 7237176, 7237194, 7237246, 7237247, 7237248, 7237249, 7237289, 7237299, 7337462, 7338780, 7408700, 7521878, 7521902, 7521945, 7521968, 7521986, 7522010, 7522034, 7522076, 7522090, 7522164, 7522191, 7522264, 7522288, 7522304, 7522322, 7522344, 7522404, 7522431, 7522450, 7522538, 7522559, 7522589, 7522614, 7522664, 7522716, 7522739, 7522846, 7522899, 7522925, 7522970, 7523025, 7523051, 7523077, 7523197, 7523223, 7523251, 7925549, 8424974, 8458020, 8458024, 8458025, 8458026, 8458027, 8458028, 8458029, 8458030, 8458032, 8458033, 8458034, 8458035, 8458036, 8458038, 8458039, 8458040, 8458041, 8458042, 8458043, 8458045, 8458047, 8458049, 8458050, 8458052, 8458053, 8458054, 8458055, 8458058, 8458059, 8458060, 8458061, 8458063, 8458064, 8458065, 8458066, 8458067, 8458070, 8458071, 8458072, 8458073, 8458074, 8458075, 8458077, 8458078, 8458079, 8458080, 8458082, 8458083, 8458084, 8458085, 8458087, 8458088, 8458090, 8458091, 8458092, 8458093, 8458094, 8458095, 8458096, 8458098, 8458099, 8458101, 8458103, 8458104, 8458105, 8458106, 8458107, 8458109, 8458110, 8458111, 8458112, 8458113, 8458114, 8458115, 8458117, 8458118, 8458119, 8458120, 8458121, 8458122, 8458124, 8458125, 8458126, 8458127, 8458128, 8458129, 8458130, 8458131, 8458132, 8458133, 8458134, 8458135, 8458136, 8458138, 8458139, 8458140, 8458141, 8458143, 8458144, 8458145, 8458146, 8458147, 8458148, 8458149, 8458150, 8458151, 8458152, 8458153, 8458154, 8458155, 8458156, 8458157, 8458160, 8458163, 8458164, 8458165, 8458169, 8458170, 8458171, 8458172, 8458174, 8458175, 8458176, 8458177, 8458178, 8458179, 8458180, 8458181, 8458182, 8458183, 8458185, 8458186, 8458187, 8458191, 8458192, 8458193, 8458194, 8458195, 8458196, 8458197, 8458198, 8458199, 8458200, 8458201, 8458203, 8458205, 8458206, 8458207, 8458208, 8458210, 8458211, 8458213, 8458214, 8458216, 8458217, 8458218, 8458220, 8458221, 8458222, 8458224, 8458226, 8458228, 8458229, 8458230, 8458232, 8458235, 8458236, 8458239, 8458240, 8458241, 8458242, 8458243, 8458245, 8458248, 8458250, 8458251, 8458252, 8458253, 8458254, 8458255, 8763049, 9159071, 9159075, 9159084, 9159093, 9159104, 9159113, 9159120, 9159124, 9598391, 9645861, 9669110, 9669152, 9671867, 9687430, 9688519, 9696019 ) 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...