Untitled query #6139

SQL

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

-- AND LENGTH(term_text) > 500
AND wblabel.term_text LIKE '% (Band)'
-- AND wbdesc.term_text = 'Band'

ORDER BY label, wblabel.term_entity_id;
SQL

Checking query status...
