Wikidata - names - Korean names

SQL

# List of Korean names and their aliases
# FIXME: include names without any current aliases

# Database scheme: https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
# without Wikidata tables (wb_entity_per_page, wb_terms)

# Last three columns can be used as basis for adding aliases or properties with the QuickStatement tool
# https://tools.wmflabs.org/wikidata-todo/quick_statements.php
#
# For discussion, see [[d:Wikidata talk:WikiProject Names]]
use wikidatawiki_p; 
SELECT 
	t1.term_text AS label, 
	t2.term_text AS aliases, 
	CONCAT('Q', t1.term_entity_id) AS Qid, 
    'Aen' AS QuickStateAction,   #change to 'P1999' to add property P1999
	CONCAT('"', t2.term_text,'"') AS Alias
FROM pagelinks, wb_entity_per_page, wb_terms As t1, wb_terms As t2 
WHERE pl_title = 'Q498782'  # includes all items linking to item Q498782 ("Korean name")
and pl_namespace = 0
and pl_from_namespace = 0
and epp_entity_type = 'item'
and pl_from = epp_page_id
and t1.term_entity_id = epp_entity_id
and t2.term_entity_id = epp_entity_id
and t1.term_entity_type = 'item' AND t1.term_language = 'en' and t1.term_type = 'label'
and t2.term_entity_type = 'item' AND t2.term_language = 'en' and t2.term_type = 'alias'
GROUP BY t1.term_entity_id, t2.term_text
SQL

Checking query status...
