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
Nikki
.
Toggle Highlighting
SQL
use wikidatawiki_p; select concat('* [[Q', term_entity_id, ']]'), term_language, term_entity_type, term_text from wb_terms where term_type = 'description' and term_language in ( 'st', 'tyv', 'ks-arab', 'mrj', 'aeb-latn', 'lbe', 'lrc', 'bqi', 'crh-cyrl', 'na', 'ruq', 'tum', 'loz', 'jut', 'aeb-arab', 'iu', 'dtp', 'khw', 'kbd', 'gom-latn', 'ltg', 'lzz', 'rif', 'hil', 'rw', 'krc', 'tt-latn', 'tcy', 'lfn', 'de-formal', 'kk-arab', 'udm', 'hif-latn', 'pfl', 'arq', 'xh', 'ko-kp', 'brh', 'sn', 'sat', 'pih', 'aa', 'lez', 'nv', 'ary', 'kk-latn', 'aeb', 'als', 'kk-cn', 'kk-tr', 'mo', 'anp', 'ti', 'tg-cyrl', 'gan-hans', 'gan-hant', 'kab', 'kk-kz', 'ku-arab', 'arn', 'sei', 'tokipona', 'fit', 'azb', 'mai' ) order by term_language, 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...