Pages, that don't have en label at Wikidata daily

Fork of Pages, that don't have arabic label at Wikidata daily by Mr. Ibrahem

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

SQL

use wikidatawiki_p; 
select *# CONCAT("Q",ips_item_id), CONCAT("Len"), CONCAT(ips_site_page)
from  pagelinks, wb_items_per_site i
join wb_terms on ips_item_id = term_entity_id 
and term_type = "label"
where i.ips_site_id='arwiki' 
and term_text like "قالب:%"

and pl_from = term_entity_id AND pl_namespace = 120 AND pl_title = 'P31'
and term_entity_id in (SELECT * FROM pagelinks JOIN wb_entity_per_page ON term_entity_id = pl_from
		WHERE pl_namespace = 0 and pl_title = "Q11266439")
	/*and i.ips_item_id not in
            (select term_entity_id from wb_terms where ips_item_id = term_entity_id and 
             term_type = "label" and term_language='en'
            and term_entity_id=i.ips_item_id)*/
group by ips_item_id
limit 20;

SQL

Checking query status...