Duplicate aliases in Wikidata

SQL

USE wikidatawiki_p;
/*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;*/
SELECT terms1.term_full_entity_id, terms1.term_language, terms1.term_text
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 = 'alias'
LIMIT 100;
SQL

Checking query status...
