(temp for the moment)

Fork of Assamese aliases with basic Latin characters by Mahir256

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

SQL

use wikidatawiki_p;

SELECT
	wby_name 		as term_type,
	wbxl_language 	as term_language,
    #wbx_text
	COUNT(wbx_id)	as labels
FROM wbt_item_terms
	INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id # E
	INNER JOIN wbt_type			ON wbtl_type_id = wby_id # B
	INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id # C
	INNER JOIN wbt_text 		ON wbxl_text_id = wbx_id # D
WHERE
    wby_id = 1
    AND
wbxl_language in (
	'en', 'as', 'bn', 'gom', 'gom-deva', 'gom-latn', 'gu', 'hi', 'kn', 'ks', 'ks-arab', 'ks-deva', 'mai', 'mni', 'ml', 'mr', 'ne', 'or', 'pa', 'pnb', 'sa', 'sat', 'sd', 'ta', 'te', 'ur'
)
GROUP BY term_language, term_type;

SQL

Checking query status...