Untitled query #43513

SQL

use wikidatawiki_p; 
select *#CONCAT("Q",wbit_item_id), CONCAT("Lar"), CONCAT(ips_site_page)
from wbt_item_terms 
	INNER JOIN wbt_term_in_lang tt
    ON wbit_term_in_lang_id = tt.wbtl_id
	#INNER JOIN wbt_type oo
    #ON tt.wbtl_type_id = oo.wby_id
	INNER JOIN wbt_text_in_lang  dd
    ON tt.wbtl_text_in_lang_id = dd.wbxl_id
	#INNER JOIN wbt_text  yy
    #ON dd.wbxl_text_id = yy.wbx_id
where tt.wbtl_type_id = 1
and dd.wbxl_language not in ( "ar" )
and wbit_item_id in (
    select ips_item_id 
    from wb_items_per_site
    where ips_site_id='arwiki' 
    and wbit_item_id = ips_item_id 
  )
limit 10000
;
SQL

Checking query status...
