Untitled query #20124

SQL

use wikidatawiki_p; 

SELECT
	term_text As Label,
	CONCAT('Q', term_entity_id) AS item

from wb_terms 
WHERE term_entity_type = 'item' # 'item' not 'property'
and term_type = 'label'         # 'label', 'description', 'alias'
and term_language in ('ar') 

	LEFT JOIN ( SELECT term_entity_id 
		FROM wb_terms
				WHERE term_entity_type = 'item'	# 'item' not 'property'
				AND term_type = 'label'	# 'label', 'description', 'alias'
				AND term_language in ('ar')		# set language with missing labels here (sample with language code "en")
                ) AS wbt       
	ON 		term_text = wbt.term_text
	WHERE 	wbt.term_text = term_text
SQL

Checking query status...
