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, CURRENT_DATE from wb_terms WHERE term_entity_type = 'item' AND term_type = 'label' AND term_entity_id IN ( 76,6279,6294,11676,19673,22212,22686,44690,63879,69319,120260,155985,158813,215057,221997,249898,256380,295492,324546,359442,463557,532279,553254,705472,816459,888007,953554,2036942,6112447,6173381,6770165,7341104 ) 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...