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 term_entity_id  in (SELECT * from pagelinks 
          				WHERE pl_title ='Q5' and pl_namespace = '0' 
          				and pl_from_namespace ='120'
                        and pl_from = term_entity_id
						) 

#and term_entity_id  in (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...