wf - Quarry

SQL

/*use wikidatawiki_p; 
SELECT term_entity_id , term_text from wb_terms 

join wb_items_per_site on  term_entity_id = ips_item_id

WHERE term_entity_type = 'item'
AND term_language = 'ar'
AND term_type = 'label'

and term_entity_id not in
(SELECT ips_item_id FROM wb_items_per_site WHERE ips_item_id = term_entity_id and ips_site_id = "arwiki"  )

and term_entity_id  in (SELECT pl_from from pagelinks  where pl_from = term_entity_id 
          				and pl_title ='Q5'
						) 

#and term_entity_id  in (select pl_from from wikidatawiki_p.pagelinks  where pl_from = term_entity_id AND (pl_title = 'P21')) 


and term_entity_id  in (SELECT pl_from FROM pagelinks WHERE pl_title = 'P21' AND pl_namespace = 120)
group by ips_item_id

limit 10;*/

USE wikidatawiki_p;
SELECT term_entity_id , term_text from wb_terms 

where term_entity_type = 'item' AND term_language = 'ar' AND term_type = 'label'
        
	LEFT JOIN pagelinks
		ON pl_from = term_entity_id AND pl_namespace = 0 AND pl_title = 'Q5'
	LEFT JOIN wb_items_per_site
		ON term_entity_id = ips_item_id AND ips_site_id = 'arwiki' 

WHERE ips_site_page IS NULL
ORDER BY term_entity_id;
SQL

Checking query status...
