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 # See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id) As item, term_text, GROUP_CONCAT( term_language ) As lang, term_type, CURRENT_DATE from wb_terms WHERE term_entity_type = 'item' AND term_language in ('en') AND term_type = 'label' AND term_entity_id IN ( 1258913, 15622241, 15622384, 15622386, 15628797, 15711431, 15726256, 15732069, 15735237, 15831739, 15838930, 15846570, 15911974, 15912097, 15912205, 15912279, 15912476, 15912700, 15916526, 15919417, 15939308, 15939360, 15939373, 15949821, 15955830, 15958770, 15958810, 15975725, 15978296, 15978315, 15981419, 15982338, 15982622, 15982624, 15983800, 16011755, 16032080, 16056833, 16138277, 16192280, 16219264, 16267698, 16272288, 16295183, 16335760, 1634777, 16365397, 16369208, 16465929, 16512042, 16514127, 16556636, 16604130, 16604131, 16611546, 16655888, 16661063, 16725798, 16727276, 16738546, 16751838, 16773653, 16781996, 16833164, 16859883, 16860605, 16866940, 16867239, 16867609, 16879151, 16903885, 16904078, 16916211, 16918252, 16919165, 16934562, 16938300, 16938318, 16944384, 16945575, 16945633, 16956689, 16963767, 16965082, 16969159, 16969164, 16969272, 16969434, 16969492, 16977244, 16978042, 16978970, 16992021, 16999206, 17000059, 17013083, 17027317, 17027318, 17126325, 17135601, 17137358, 17137885, 17144491, 17146675, 17148318, 17197404, 17204554, 17235331, 17237637, 17252479, 17267755, 17280586, 17287153, 17288289, 17289070, 17291020, 17292530, 17295231, 17295237, 17297763, 17305270, 17318471, 17321434, 17341651, 17351185, 17351602, 17355945, 17361190, 17379602, 17379731, 17389200, 17394734, 17407670, 17412751, 17413094, 17451535, 17456279, 17469736, 17488015, 17489865, 17496816, 1750072, 17502092, 17502111, 17505770, 17507198, 17515903, 17516086, 17557120, 17571088, 17584589, 17593432, 17606701, 17627371, 17635872, 17649628, 17736942, 17779651, 17780705, 18011015, 18011641, 18016625, 18016626, 18049856, 18072957, 18084614, 18086602, 18086603, 18086604, 18104835, 18111628, 18123045, 18123061, 18123317, 18145397, 18145508, 18172916, 18175726, 18177230, 18195756, 18196384, 18200474, 18220826, 18327257, 18327704, 18340313, 18343351, 18346411, 18396646, 18400775, 18421388, 18533416, 18533432, 18534373, 18539733, 18539828, 18544826, 18545325, 18574654, 18575021, 18575850, 18604670, 18614814, 18617010, 18634286, 18638502, 18640955, 18642230, 18647205, 18647978, 18654343, 18666851, 18667616, 18683472, 18693248, 18694447, 18694471, 18706719, 18716352, 18744492, 18748299, 18749316, 18752815, 18753961, 18758776, 18763326, 18786895, 18786918, 18822514, 18883369, 18901086, 18907502, 18910330, 18910396, 18913135, 18913402, 18915138, 18915169, 18918546, 18918598, 18936450, 18960783, 18967745, 18982418, 18985482, 18994987, 19006796, 19008101, 19008467, 19012068, 19015808, 19017118, 19017307, 19017634, 19019103, 19119672, 19160208, 19245712, 19249879, 19258118, 19276339, 19286631, 19286640, 19291561, 19301525, 19302557, 19308614, 19309866, 19317888, 19326911, 19327013, 19327022, 19355237, 19356636, 19358453, 19359492, 19359620, 19366645, 19367015, 19368387, 1938310, 19390712, 19391416, 19400085, 19404747, 19413936, 19414199, 19428335, 19468748, 19471223, 19471522, 19472037, 19477726, 19516940, 19532936, 19567952, 19567956, 19568508, 19571079, 19574549, 19574671, 19574907, 19595502, 19601656, 19603618, 19618226, 19635280, 19637132, 19659010, 19660816, 19678130, 19689221, 19689913, 19701671, 19706772, 19753728, 19768288, 19768319, 19798392, 19798834, 19798892, 19801003, 19816579, 19819894, 19820162, 19820562, 19822472, 19826126, 19829737, 19830236, 2284790, 2600726, 2720778 ) GROUP BY term_text, 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...