(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 * from wbt_item_terms limit 10;
select * from wbt_property_terms limit 10;
select * from wbt_term_in_lang limit 10;
select * from wbt_text_in_lang limit 10;
select * from wbt_type limit 10;
select * from wbt_text limit 10;

SELECT
	a.wbxl_language as term_language,
    COUNT(b.wbit_id) as labels
FROM wbt_item_terms a
	INNER JOIN wbt_term_in_lang b ON wbit_term_in_lang_id = wbtl_id
WHERE
	term_language in (
		'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
ORDER BY labels DESC;

SQL

Checking query status...