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 (SELECT * FROM wb_terms WHERE term_type = "label") AS labels
JOIN (SELECT * FROM wb_terms WHERE term_type = "alias") AS aliases
	ON (labels.term_full_entity_id, labels.term_entity_type, labels.term_language, labels.term_text)
GROUP BY labels.term_entity_type, labels.term_full_entity_id, labels.term_language, labels.term_text
ORDER BY labels.term_entity_type, labels.term_full_entity_id, labels.term_language, labels.term_text
LIMIT 1;

SQL

Checking query status...