some item descriptions/labels in Wikidata

SQL

USE wikidatawiki_p; /*
#SELECT term_entity_id, term_language, term_text FROM wb_terms
WHERE term_type = 'description' 
AND term_language = 'nl' 
AND term_text RLIKE '.+\\s{2,}.+'#= "город в Италии" 
AND term_entity_type = 'item'
#ORDER BY term_language, term_entity_id, term_text;
*/
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 = 'en' 
		AND w2.term_type = 'description'#'label'  # 'description', 'alias'
		AND w2.term_text = "Wikimedia category"#Wikimedia template" #like "%политики"#RLIKE '^dorp {2,}'like "%(dezambiguizare)"
     */   and 
        (w1.term_entity_type = 'item' 
		AND w1.term_language = 'nl' 
		AND w1.term_type = 'label' AND (w1.term_text /*not*/ like "Kategorie:%" or w1.term_text /*not*/ like "Catégorie:%"))
GROUP BY /*w2.term_text,*/ w2.term_entity_id
limit 10100
SQL

Checking query status...
