Disambiguations to be merged (cswiki)

SQL

USE wikidatawiki_p;
SELECT labels.term_entity_type, labels.term_full_entity_id, labels.term_language, labels.term_text
FROM wb_terms AS labels
JOIN wb_terms AS aliases
	ON (labels.term_full_entity_id = aliases.term_full_entity_id AND labels.term_language = aliases.term_language
        AND labels.term_text = aliases.term_text)
WHERE labels.term_type = "label" AND aliases.term_type = "alias"
GROUP BY labels.term_full_entity_id, labels.term_language, labels.term_text
ORDER BY labels.term_full_entity_id, labels.term_language, labels.term_text
LIMIT 1;

SQL

Checking query status...