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
Mahir256
.
THIS QUERY NO LONGER WORKS--SEE https://www.wikidata.org/wiki/User:Mr._Ibrahem/Language_statistics_for_items INSTEAD! (Had to split the query since it kept getting killed lately. The rest of the languages are tracked in query #31655.) Thanks, Pasleim, for the original query!
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT CURRENT_DATE; SELECT term_entity_type, term_language, count(if(term_type = 'label',1,null)) as labels, count(if(term_type = 'description',1,null)) as descriptions, count(if(term_type = 'alias',1,null)) as aliases FROM wb_terms WHERE term_language IN ( 'anp', 'as', 'awa', 'bcc', 'bgn', 'bho', 'bn', 'bpy', 'brh', 'dty', 'dv', 'dz', 'gom', 'gom-deva', 'gom-latn', 'gu', 'hi', 'khw', 'kn', 'ks', 'ks-arab', 'ks-deva', 'lus', 'mai', 'ml', 'mr', 'ne', 'new', 'or', 'pa', 'pi', 'pnb', 'ps', 'rwr', 'sa', 'sat', 'sd', 'si', 'skr-arab', 'ta', 'tcy', 'te', 'ur' ) GROUP BY term_entity_type, term_language ORDER BY term_language;
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...