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 pagelinks 
WHERE pl_namespace = '0'
and pl_from_namespace ='120'
limit 10;
 /*
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 wikidatawiki_p.pagelinks  where pl_from = term_entity_id
AND (pl_title = 'Q5') AND pl_namespace = 0) 
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...