mysql:[email protected] [wikidatawiki]> SELECT   wbit_item_id as id,   wby_name as type,   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_type ON wbtl_type_id = wby_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 = 1 860 and wby_name = 'label' and wbxl_language = 'en';
Empty set (0.01 sec)

mysql:[email protected] [wikidatawiki]> select * from wbt_text where wbx_text = 'English';
 ---------- ---------- 
| wbx_id   | wbx_text |
 ---------- ---------- 
| 89986287 | English  |
 ---------- ---------- 
1 row in set (0.00 sec)

mysql:[email protected] [wikidatawiki]> SELECT
    ->   wbit_item_id as id,
    ->   wby_name as type,
    ->   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_type ON wbtl_type_id = wby_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 wbx_text = 'English'
    -> AND wby_name = 'label'
    -> AND wbxl_language = 'en';
 ---------- ------- ---------- --------- 
| id       | type  | language | text    |
 ---------- ------- ---------- --------- 
| 28224411 | label | en       | English |
 ---------- ------- ---------- --------- 
1 row in set (0.00 sec)

mysql:[email protected] [wikidatawiki]> SELECT
    ->   wbit_item_id as id,
    ->   wby_name as type,
    ->   wbxl_language as language,
    ->   wbx_text as 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 = 1860
    -> AND wbxl_language = 'en'
    -> AND wby_name = 'label';
 ------ ------- ---------- --------- 
| id   | type  | language | text    |
 ------ ------- ---------- --------- 
| 1860 | label | en       | English |
 ------ ------- ---------- --------- 
1 row in set (0.00 sec)

mysql:[email protected] [wikidatawiki]> SELECT
    ->    wbit_item_id as id,
    ->    wby_name as type,
    ->    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_type ON wbtl_type_id = wby_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 wbx_text = 'English'
    ->  AND wby_name = 'label'
    ->  AND wbxl_language = 'en';
 ---------- ------- ---------- --------- 
| id       | type  | language | text    |
 ---------- ------- ---------- --------- 
|     1860 | label | en       | English |
| 28224411 | label | en       | English |
 ---------- ------- ---------- --------- 
2 rows in set (0.00 sec)