Untitled query #6109

SQL

USE wikidatawiki_p;
SELECT
	CONCAT("Q", l.term_entity_id) AS qid,
	'Lja',
--    '"huyện"' AS label
    CONCAT('"', REPLACE(l.term_text, " (huyện)", ""), '"') AS label,
    d.term_text
FROM wb_terms l
LEFT JOIN wb_terms d on d.term_entity_id = l.term_entity_id
WHERE l.term_language = 'ja'
AND l.term_type = 'label'
AND l.term_entity_type = 'item'

AND d.term_language = 'ja'
AND d.term_type = 'label'
AND d.term_entity_type = 'item'

-- AND LENGTH(term_text) > 500
AND l.term_text regexp 'の曲'

ORDER BY label, l.term_entity_id;
SQL

Checking query status...
