details of duplicated ceb disamb

SQL

USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id), term_language, term_text
FROM wb_terms/*
JOIN wb_entity_per_page
	ON term_entity_id=epp_entity_id*/
WHERE
	term_type='label' AND
	term_entity_type='item' AND
#    term_text REGEXP '^[A-Za-z\s]+$' AND#^[A-Z]{3,}[[:space:]][A-Z]{3,}$
    term_language = 'ko' AND
#    epp_entity_type='item' AND
    term_entity_id IN (SELECT t1.term_entity_id
      FROM wb_terms t1
      WHERE t1.term_type='label' AND
	t1.term_entity_type='item' AND
    t1.term_language = 'en' AND
    t1.term_text is NULL
    )

SQL

Checking query status...