Untitled query #20883

SQL

USE enwiki_p;
SELECT eu_entity_id, ar.term_text#, COUNT(*)
	FROM (SELECT * FROM wbc_entity_usage WHERE eu_aspect = "L.ar") AS eusage
	JOIN wikidatawiki_p.page
		ON page_namespace = 0 AND page_title = eu_entity_id
	JOIN wikidatawiki_p.wb_entity_per_page
		ON epp_entity_type = "item" AND epp_page_id = page_id
	LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = "label" AND term_language = "ar"
               AND term_entity_type = "item") AS ar
		ON ar.term_entity_id = epp_entity_id
	#LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = "label" AND term_language = "en" AND term_entity_type = "item") AS en
		#ON en.term_entity_id = epp_entity_id
#WHERE ar.term_text IS NULL
WHERE ar.term_text like "%"
#GROUP BY eu_entity_id HAVING COUNT(*) > 2
#ORDER BY COUNT(*) DESC, IF(en.term_text IS NULL, 1, 0), epp_entity_id
limit 50;
SQL

Checking query status...
