wf - Quarry

Fork of Wikidata - wb_terms - sample data (items with ar labels) by Mr. Ibrahem

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

use wikidatawiki_p; 
SELECT * 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 exists (select * from wikidatawiki_p.pagelinks  where pl_from = term_entity_id
AND (pl_title = 'Q5') AND pl_namespace = 0) 
and exists (select * from wikidatawiki_p.pagelinks  where pl_from = term_entity_id
AND (pl_title = 'P21')) 
group by ips_item_id

limit 10;

SQL

Checking query status...