Untitled query #47888

SQL

use fiwiki_p;
select iwl1, wbx1.wbx_text, wbx2.wbx_text  from (
select 
	iwl1.iwl_title as iwl1, 
    iwl2.iwl_title as iwl2 
from iwlinks as iwl1 
LEFT JOIN (
  select iwlinks.*  
  from iwlinks,categorylinks 
  where 
  	cl_from=iwl_from 
  	and cl_to="Luettelot_Helsingin_rakennuksista_ja_rakennelmista"
) as iwl2 
ON iwl1.iwl_title=iwl2.iwl_title
where iwl1.iwl_from = 1593353  
) as t,
wikidatawiki_p.wbt_item_terms 
LEFT JOIN wikidatawiki_p.wbt_term_in_lang as wbtl1 ON wbit_term_in_lang_id=wbtl1.wbtl_id AND wbtl1.wbtl_type_id=1
LEFT JOIN wikidatawiki_p.wbt_text_in_lang as wbxl1 ON wbtl1.wbtl_text_in_lang_id=wbxl1.wbxl_id AND wbxl1.wbxl_language='fi'  
LEFT JOIN wikidatawiki_p.wbt_text as wbx1 ON wbxl1.wbxl_text_id=wbx1.wbx_id 

LEFT JOIN wikidatawiki_p.wbt_term_in_lang as wbtl2 ON wbit_term_in_lang_id=wbtl2.wbtl_id AND wbtl2.wbtl_type_id=2
LEFT JOIN wikidatawiki_p.wbt_text_in_lang as wbxl2 ON wbtl2.wbtl_text_in_lang_id=wbxl2.wbxl_id AND wbxl2.wbxl_language='fi'  
LEFT JOIN wikidatawiki_p.wbt_text as wbx2 ON wbxl2.wbxl_text_id=wbx2.wbx_id 

where 
    wbit_item_id=REPLACE(iwl1, "Q", "")
	AND iwl2 IS NULL
SQL

Checking query status...
