(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
	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
	wbit_item_id = 321
;

SQL

Checking query status...