A - Quarry

SQL

use wikidatawiki_p; 
select CONCAT("Q",term_entity_id ), CONCAT("Lar"), CONCAT('"',term_text,'"')
		from wb_terms i
	where i.term_type = "label"
    and i.term_entity_type = 'item' 
	and i.term_language='ar'
and not exists
			(select ips_item_id from wb_items_per_site  where ips_site_id = 'arwiki' and ips_item_id = i.term_entity_id)
and  exists
			(select * from pagelinks  where pl_from = i.term_entity_id AND (pl_title = 'P21') AND pl_namespace = 120  
             and pl_from_namespace = 0)
and  exists
			(select * from pagelinks  where pl_from = i.term_entity_id AND (pl_title = 'Q5')   AND pl_namespace = 0 
             and pl_from_namespace = 0)


group by i.term_entity_id
limit 10;
SQL

Checking query status...
