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 CURRENT_DATE; SELECT term_language, count(*) as c FROM wb_terms WHERE term_language IN ( 'abe', 'ady-cyrl', 'aeb-arab', 'azb', 'abe', 'ady-cyrl', 'aeb-arab', 'azb', 'atj', 'bxr', 'dty', 'ett', 'fkv', 'bxr', 'bbc-latn', 'be-tarask', 'bh', 'bto', 'be-tarask', 'crh-cyrl', 'crh-latn', 'de-at', 'de-formal', 'dty', 'ett', 'fkv', 'gan-hans', 'gan-hant', 'hif-latn', 'hrx', 'ike-cans', 'ike-latn', 'kbd-cyrl', 'ko-kp', 'koy', 'ku-arab', 'kbd-cyrl', 'ko-kp', 'koy', 'ku-arab', 'kbp', 'kk-arab', 'kk-cn', 'kk-cyrl', 'kk-kz', 'kk-latn', 'kk-tr', 'ko-kp', 'ks-arab', 'ks-deva', 'ku-arab', 'lld', 'lbe', 'lbe', 'lld', 'mo', 'moe', 'mo', 'moe', 'nl-informal', 'nys', 'nod', 'nl-informal', 'nys', 'nod', 'nah', 'nl-informal', 'nod', 'nys', 'otk', 'olo', 'otk', 'roa-tara', 'rwr', 'roa-tara', 'rwr', 'shi-latn', 'shi-tfng', 'sje', 'shi-latn', 'shi-tfng', 'sje', 'tzl', 'tzl', 'ug-arab', 'ug-latn', 'uz-cyrl', 'uz-latn', 'zh-mo', 'zh-my', 'zh-cn', 'zh-hk', 'zh-sg', 'zh-tw', 'zh-mo', 'zh-my', 'mo', 'pnb', 'pt-br', 'ruq', 'ruq-cyrl', 'ruq-latn', 'shi-latn', 'shi-tfng', 'sje', 'sr-ec', 'sr-el', 'srq', 'tg-cyrl', 'tg-latn', 'tt-cyrl', 'tt-latn', 'cdo', 'bcc', 'bgp', 'cja', 'cja-cham', 'cja-latn', 'cja-arab', 'cjy', 'cjy-hans', 'cjy-hant', 'dlc', 'eml', 'gom-deva', 'gom-latn', 'knn', 'lki', 'luz', 'mhr', 'mui', 'olo', 'pnb', 'prs', 'shy', 'shy-latn', 'shy-tfng', 'ydd', 'ku-latn' ) GROUP BY term_language ORDER BY c DESC;
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...