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
.
runtime > 5 min
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id) As itemID, term_text, GROUP_CONCAT( term_language ) AS langs from wb_terms WHERE term_entity_type = 'item' and term_type = 'label' and term_entity_id IN ( 1114186, 1152010, 120009, 120135, 120175, 120224, 120648, 120665, 120702, 120707, 120857, 120868, 120899, 120905, 120943, 120945, 120949, 120963, 120970, 121327, 121331, 121345, 121461, 121554, 121565, 121625, 121641, 121675, 121679, 121969, 122210, 122233, 122258, 122325, 122348, 122357, 122524, 122712, 123104, 123240, 123272, 123384, 123388, 123399, 123648, 123768, 123800, 123869, 123895, 123901, 123936, 123988, 124030, 124071, 124076, 124091, 124096, 124224, 124235, 124317, 124406, 124445, 124449, 124492, 124496, 124520, 124537, 124569, 124579, 124605, 124611, 124614, 124630, 124672, 124708, 124716, 124737, 124765, 124796, 125064, 125086, 125129, 125253, 125259, 125281, 125288, 125422, 125463, 125511, 125573, 125586, 125597, 125619, 125697, 125723, 125760, 125766, 125793, 125799, 126103, 126175, 126184, 126202, 126426, 126437, 126491, 126509, 126562, 126649, 126792, 126809, 126821, 126838, 126983, 126985, 127919, 129458, 129486, 134024, 137472, 137938, 139484, 139527, 140162, 144487, 145124, 145143, 145226, 152080, 159956, 160129, 160729, 162769, 163993, 165624, 165729, 167815, 168156, 168208, 168979, 168987, 169002, 169036, 169075, 174325, 174437, 176570, 177300, 178409, 178773, 179547, 179878, 180291, 182297, 184699, 18608042, 189680, 19102604, 191318, 19335645, 19660980, 197086, 197098, 197106, 203190, 205238, 206274, 206477, 207008, 207160, 214180, 215059, 215104, 215265, 215278, 215288, 215294, 215312, 215385, 215494, 215544, 215713, 216150, 216152, 216228, 216242, 216352, 216355, 216443, 216472, 216549, 216606, 216624, 216682, 216684, 218945, 218970, 220496, 220525, 220661, 220803, 221850, 223226, 227124, 227334, 228576, 3854795, 4113754 ) AND term_language Not IN ( 'ar', 'be', 'be-tarask', 'bg', 'el', 'fa', 'he', 'ja', 'ka', 'ko', 'mk', 'ru', 'sr', 'th', 'uk', 'zh', 'zh-hans', 'zh-cn', 'zh-sg', 'zh-hant', 'zh-tw', 'zh-hk' ) GROUP BY term_text ORDER BY term_entity_id
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...