Duplicate aliases in Wikidata

SQL

USE wikidatawiki_p;
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 5000;
SQL

Checking query status...
