SQL
x
USE wikidatawiki_p;
SELECT DISTINCT
CONCAT("Q", term_entity_id) AS qid,
term_type,
term_text AS molabel,
term_language
FROM wb_terms
WHERE term_entity_type = 'item'
AND term_language IN (
'als', 'bat-smg', 'be-x-old', 'bh', 'de-formal', 'fiu-vro', 'nl-informal', 'no', 'roa-rup', 'simple', 'zh-classical', 'zh-min-nan', 'zh-yue'
)
ORDER BY term_language, 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.
All SQL code is licensed under CC0 License.