Untitled query #17591

SQL

use wikidatawiki_p;
Select wbit_itwm_id from wbt_text 

LEFT JOIN wbt_text_in_lang ON wbxl_text_id = wbx_id
LEFT JOIN wbt_term_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_item_terms ON wbit_term_in_lang_id = wbtl_id
where wbx_text= "தமிழ்நாடு" 
AND wbtl_type_id = '1';
SELECT
  wbit_item_id as id,
  wbxl_language as language,
  wbx_text as text
FROM wbt_item_terms
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbit_item_id = 668#india item id
AND wbtl_type_id = '1'#type id for label not description or alias
AND wbxl_language = 'ta';
SQL

Checking query status...
