Untitled query #6173

SQL

USE wikidatawiki_p;
SELECT DISTINCT
	CONCAT("Q", wbdesc.term_entity_id) AS qid,
	CONCAT("D", wbdesc.term_language) AS lang,
 	CONCAT('"', REPLACE(wbdesc.term_text, '\\u00E9', "é"), '"') AS label 
FROM wb_terms wbdesc
-- LEFT JOIN wb_terms wblabel
-- ON wblabel.term_entity_id = wbdesc.term_entity_id
-- AND wblabel.term_language = wbdesc.term_language
-- AND wblabel.term_entity_type = wbdesc.term_entity_type

WHERE wbdesc.term_entity_type = 'item'
-- AND wblabel.term_type = 'label'
AND wbdesc.term_type = 'description'
-- AND wbdesc.term_language = 'en'

AND wbdesc.term_text = 'comt\\u00E9 am\\u00E9ricain de l''\\u00E9tat du Kentucky'

ORDER BY wbdesc.term_entity_id;
SQL

Checking query status...
