Label/description/alias stats for South Asian tongues on Wikidata

Fork of Label/description/alias stats for 8th Schedule tongues by Mahir256

This query is marked as a draft This query has been published by Titodutta.

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', 'mni', '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;

SQL

Checking query status...