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, 'welsh ', "Welsh "), '"') 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 REGEXP '	'
AND wbdesc.term_text LIKE '% welsh %' -- REGEXP '   '

ORDER BY wbdesc.term_entity_id;
SQL

Checking query status...
