Duplicate aliases in Wikidata

SQL

USE wikidatawiki_p;
/*
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' AND terms1.term_row_id <> terms2.term_row_id
LIMIT 1;
*/
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id, wbxl_language, (SELECT wbx_text FROM wbt_text WHERE wbx_id = wbxl_text_id) AS text
FROM wbt_item_terms   AS Lwbit
JOIN wbt_term_in_lang AS Lwbtl ON Lwbtl.wbtl_id = Lwbit.wbit_term_in_lang_id
JOIN wbt_type         AS Ly    ON Ly.wby_id = Lwbtl.wbtl_type_id
JOIN wbt_item_terms   AS Awbit ON Awbit.wbit_item_id = Lwbit.wbit_item_id
JOIN wbt_term_in_lang AS Awbtl ON Awbtl.wbtl_id = Awbit.wbit_term_in_lang_id
JOIN wbt_type         AS Ay    ON Ay.wby_id = Awbtl.wbtl_type_id
JOIN wbt_text_in_lang          ON wbxl_id = Awbtl.wbtl_text_in_lang_id
#JOIN wbt_text                  ON wbx_id = wbxl_text_id
WHERE Ly.wby_name = 'label' AND Ay.wby_name = 'alias'
AND Lwbtl.wbtl_text_in_lang_id = Awbtl.wbtl_text_in_lang_id
#AND wbxl_language = 'cs'
LIMIT 1000;
SQL

Checking query status...
