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 5000;
/*
SELECT wbit_item_id, wbxl_language, wbx_text
FROM wbt_item_terms
JOIN wbt_term_in_lang AS Aterm ON Aterm.wbit_term_in_lang_id = wbtl_id
JOIN wbt_term_in_lang AS Lterm ON Lterm.wbit_term_in_lang_id = wbtl_id
JOIN wbt_type AS Ay   ON Aterm.wbtl_type_id = Ay.wby_id
JOIN wbt_type AS Ly   ON Lterm.wbtl_type_id = Ly.wby_id
JOIN wbt_text_in_lang ON Lterm.wbtl_text_in_lang_id = wbxl_id AND Aterm.wbtl_text_in_lang_id = wbxl_id
JOIN wbt_text         ON wbxl_text_id = wbx_id
LIMIT 1;
*/
SQL

Checking query status...
