sq - Quarry

SQL

use wikidatawiki_p; 
select CONCAT("Q",ips_item_id), CONCAT(term_text)#, CONCAT(ips_site_page),ips_site_id
from wb_items_per_site i
join wb_terms on ips_item_id = term_entity_id# and term_type = "label"
where term_entity_type = "item"

and term_type = "label" 
and term_language='ar'
/*
and i.ips_item_id  in
(select term_entity_id AS YEEE from wb_terms 
 where ips_item_id = 
 term_entity_id and 
 term_type = "label" and term_language='ar') 
*/
and i.ips_item_id  not in
(SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = "arwiki" )

group by ips_item_id
limit 10;
SQL

Checking query status...
