Labels in English for items whose names begin with "The"

Fork of Labels in English for items whose names begin with "The" by XXN

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

SQL

use wikidatawiki_p; 
SELECT 
	CONCAT('Q', w2.term_entity_id) As item,
	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 = 'label'  # 'description', 'alias'
		AND w2.term_text LIKE 'Top %'
        and 
        (w1.term_entity_type = 'item' 
		AND w1.term_language = 'en' 
		AND w1.term_type = 'alias')
GROUP BY w2.term_text, w2.term_entity_id

SQL

Checking query status...