search in WD descriptions, labels

SQL

use wikidatawiki_p; 
SELECT CURRENT_TIMESTAMP;
SELECT 
	CONCAT('Q', w2.term_entity_id) as item,
	w1.term_text as label,
	CONCAT('"', w2.term_text, '"') as descr#,
#	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 '^.+\\s+.+$'#like "%политики"#RLIKE '^dorp {2,}'
        and 
        (w1.term_entity_type = 'item' 
		AND w1.term_language = 'en' 
		AND w1.term_type = 'label')
GROUP BY w2.term_text, w2.term_entity_id
limit 1010
SQL

Checking query status...
