Untitled query #6173

SQL

USE wikidatawiki_p;
SELECT
	CONCAT("Q",wblabel.term_entity_id) AS qid,
	'Den',
 	CONCAT('"', REPLACE(wblabel.term_text, "", ""), '"') AS label 
FROM wb_terms wblabel
LEFT JOIN wb_terms wbdesc
ON wblabel.term_entity_id = wbdesc.term_entity_id
AND wbdesc.term_language = 'en'
AND wbdesc.term_type = 'description'
AND wbdesc.term_entity_type = 'item'
WHERE wblabel.term_language = 'en'
AND wblabel.term_type = 'label'
AND wblabel.term_entity_type = 'item'

AND wblabel.term_text LIKE ' %'

ORDER BY wblabel.term_entity_id;
SQL

Checking query status...
