(temp for the moment)

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
	wbxl_language 	as term_language,
	wby_name 		as term_type,
	wbx_text 		as term_text
FROM wbt_item_terms
	INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
	INNER JOIN wbt_type			ON wbtl_type_id = wby_id
	INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
	INNER JOIN wbt_text 		ON wbxl_text_id = wbx_id
WHERE
	wbxl_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'
	)
;
SQL

Checking query status...
