Wikidata - Descriptions ending with "।"

Fork of Wikidata - English descriptions starting with "a .." by Jura1

This query is marked as a draft This query has been published by Mahir256.

SQL

#See    https://www.wikidata.org/wiki/Help:Description#No_initial_articles_.28a.2C_an.2C_the.29

#Initial run: about 13000, later 8000

#run on 2017-09-07: 26,952
SELECT CURRENT_DATE;
use wikidatawiki_p; 
SELECT 
	CONCAT('Q', term_entity_id) As item, 
	CONCAT('D', term_language) As tr,
	CONCAT('"', term_text, '"') As current_desc,
from 	wb_terms 
WHERE 	term_entity_type = 'item' 
		AND term_type = 'description'    # 'label', 'description', 'alias'
		AND (term_text LIKE '%।')
GROUP BY term_language
ORDER BY term_language DESC

SQL

Checking query status...