(temp for the moment)

SQL

use wikidatawiki_p;

# First run....
# as, Executed in 787.56 seconds as of Tue Mar 24 2020.
# bn, Executed in 1809.17 seconds as of Tue Mar 24 2020.

SELECT
    wby_name as term_type,
    term_language,
    terms
FROM (

SELECT
    wbtl_type_id as term_type_id,
    wbxl_language as term_language,
    count(*) as terms
FROM wbt_item_terms
    INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id # A
    INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id # B
  WHERE  wbxl_language in ('as', 'bn')
GROUP BY wbtl_type_id

) a
INNER JOIN wbt_type ON term_type_id = wby_id;
#     '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...
