Duplicate aliases in Wikidata

SQL

USE wikidatawiki_p;
SELECT terms1.term_full_entity_id, terms1.term_language, terms1.term_text, terms2.term_type
FROM wb_terms AS terms1 JOIN wb_terms AS terms2 USING (term_full_entity_id, term_language, term_type, term_text)
WHERE terms1.term_type = 'alias' AND terms1.term_row_id <> terms2.term_row_id
LIMIT 10000;
/*
SELECT terms1.term_full_entity_id, terms1.term_language, terms1.term_text, terms2.term_type
FROM wb_terms AS terms1, wb_terms AS terms2
WHERE terms1.term_full_entity_id = terms2.term_full_entity_id
AND terms1.term_language = terms2.term_language
AND terms1.term_text = terms2.term_text
AND terms1.term_type = 'alias' AND (
  terms2.term_type = 'label' OR (
    terms2.term_type = 'alias' AND terms1.term_row_id <> terms2.term_row_id
  )
)
LIMIT 2000;
/*
SELECT term_full_entity_id, term_language, term_text, COUNT(*) FROM wb_terms
WHERE term_type = 'alias'
GROUP BY term_full_entity_id, term_language, term_text HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC, term_language, term_full_entity_id, term_text
LIMIT 500;
*/
SQL

Checking query status...
