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 * 
from wb_terms# , pagelinks#, wb_items_per_site
	LEFT JOIN wb_items_per_site
		ON term_entity_id = ips_item_id AND ips_site_id = 'arwiki' 
	 JOIN pagelinks
		ON pl_from = term_entity_id AND pl_namespace = 120 AND pl_title = 'P31'

	LEFT JOIN pagelinks aa
		ON aa.pl_from = term_entity_id AND aa.pl_namespace = 0 AND aa.pl_title = 'Q11266439'

AND term_language = 'ar'  AND term_type = 'label'
and term_text like "قالب:%"

#ORDER BY term_entity_id
GROUP BY term_entity_id
limit 10;

SQL

Checking query status...