Wikidata - English descriptions starting with "a .."

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

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

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,
    LENGTH(term_text) as strl,
    term_entity_id
from 	wb_terms 
WHERE 	term_entity_type = 'item' 
		AND term_language = 'en' 
		AND term_type = 'description'    # 'label', 'description', 'alias'
		AND (term_text LIKE 'a %'
		OR term_text LIKE 'an %'
		OR term_text LIKE 'A %'
		OR term_text LIKE 'An %')
GROUP BY term_text, term_entity_id
ORDER BY term_entity_id DESC

SQL

Checking query status...