search in WD descriptions, labels

SQL

use wikidatawiki_p; 
SELECT 
	CONCAT('Q', w2.term_entity_id) As item,
	CONCAT('"', w2.term_text, '"') As descr,
	CONCAT('"', w2.term_text, '"') As label,
#	GROUP_CONCAT(w1.term_text separator ' *, ') As alias,
	CURRENT_DATE
from 	wb_terms w2 join wb_terms w1 on w2.term_entity_id = w1.term_entity_id
WHERE 	w2.term_entity_type = 'item' 
		AND w2.term_language = 'nl' 
		AND w2.term_type = 'description'#'label'  # 'description', 'alias'
		AND w2.term_text RLIKE '^dorp\s+%$'
/*        and 
        (w1.term_entity_type = 'item' 
		AND w1.term_language = 'nl' 
		AND w1.term_type = 'label')*/
GROUP BY w2.term_text, w2.term_entity_id
limit 3
SQL

Checking query status...
