Label/description/alias stats for 8th Schedule tongues

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!

SQL

USE wikidatawiki_p;

SELECT
	term_entity_type,
	term_type,
    term_language,
	count(term_type = 'label') as l,
    count(term_type = 'description') as d,
    count(term_type = 'alias') as a
FROM wb_terms
WHERE term_language IN (
	'as', 'bn', 'bpy', 'hi', 'ne', 'new', 'ta', 'te', 'kn', 'ml', 'gu', 'pa', 'or', 'sa', 'mr', 'bho', 'dty', 'mai', 'anp', 'awa', 'ks-deva', 'gom-deva', 'pi', 'rwr', 'tcy', 'ur', 'sd', 'ks-arab', 'gom-latn' # 'pnb', 'ps', 'dz', 'dv', 'si', 'bcc', 'bgn'
)
GROUP BY term_entity_type, term_language;

SQL

Checking query status...