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.

http://quarry.wmflabs.org/query/5774

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
		ON pl_from = term_entity_id AND pl_namespace = 0 AND 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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...