ss - Quarry

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",term_entity_id) AS item, term_text AS label#, pi_type
	FROM wb_terms
#	LEFT JOIN wb_terms
#		ON term_entity_id = pi_property_id AND term_entity_type = 'property' AND term_language = 'en' AND term_type = 'label'
	LEFT JOIN pagelinks
		ON pl_from = term_entity_id AND pl_namespace = 0 AND pl_title = 'Q5'
#WHERE pl_title IS NULL
WHERE term_entity_type = 'item' AND term_language = 'ar' AND term_type = 'label'
and pl_from = term_entity_id
GROUP BY term_entity_id
limit 10;
SQL

Checking query status...
