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_type = "label" and term_language='ar'
AND NOT ips_site_id='arwiki'

and i.ips_item_id  in
(
SELECT term_entity_id FROM wb_terms WHERE term_type ="label" AND term_entity_type = "item" 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...
