User:Akkakk/issues/disambiguation conflicts

select concat("[[Q", t1.term_entity_id, "]]") as item, t1.term_language as lang1, t1.term_text as en_label, t2.term_language as lang2, t2.term_text as de_label from wb_terms as t1 join wb_terms as t2 on t1.term_entity_id = t2.term_entity_id where t1.term_text != t2.term_text and t1.term_language = "en" and t1.term_type = "label" and t1.term_entity_type = "item" and t2.term_language != "en" and t2.term_type = "label" and t2.term_entity_type = "item" and exists (select * from wb_terms as t3 where t3.term_entity_id = t1.term_entity_id and t3.term_entity_type = "item" and t3.term_language = "en" and t3.term_type = "description" and t3.term_text = "Wikipedia disambiguation page") limit 25,50;

1 Q3179268 en Jiro fr Jirō
2 Q3179268 en Jiro pl Jirō
3 Q3179268 en Jiro es Jirō
4 Q3474871 en French ship Saône fr Saône
5 Q3492475 en Sovkino ru Совкино
6 Q3492475 en Sovkino pl Sowkino
7 Q3519068 en Bank stress tests fr Test de résistance
8 Q3104937 en Ghost in comics fr Ghost
9 Q3104937 en Ghost in comics es Ghost (historietas)
10 Q1267524 en Dursun tr Dursun (anlam ayrımı)
11 Q1333530 en Alsace-Lorraine P 1 de Elsaß-Lothringische P 1
12 Q1496008 en RV Belgica hu A962 Belgica
13 Q1797321 en Kürsat de Kürşat
14 Q1797321 en Kürsat tr Kürşat
15 Q1879542 en Lí Ban fr Libane
16 Q1951928 en Muhiddin de Muhittin
17 Q1951928 en Muhiddin hu Muhittin
18 Q1951928 en Muhiddin tr Muhittin
19 Q2111323 en Priya ta ப்ரியா
20 Q2204286 en Rifat de Rıfat
21 Q2401083 en Tekin ru Текин
22 Q343786 en Ilker de İlker
23 Q405428 en Aiman nl Yaman
24 Q482078 en Acél hu Acél (családi név)
25 Q793403 en Ayik de Ayık
26 Q816149 en Von Below ru Беловы
27 Q816149 en Von Below de Below (Adelsgeschlecht)
28 Q3077075 en Ford Everest fr Ford Endeavour
29 Q3077075 en Ford Everest ja フォード・エベレスト
30 Q896795 en Brad Hall fr Bradley Hall
31 Q4528015 en Daisuke ko 다이스케
32 Q222523 en Arturo sv Artur#Personer med namnet Artur eller Arthur
33 Q1556601 en Gustav von Bezold fr Gustav Bezold
34 Q5306165 en Draža sr Дража
35 Q5307762 en Drinčić sr Дринчић
36 Q5308164 en Drobnjak sr Дробњак
37 Q5318303 en Dwivedi hi द्विवेदी
38 Q1031816 en Can de Can (Name)
39 Q1031816 en Can he קאן
40 Q5876352 en Hodžić sr Хоџић
41 Q5880061 en Hole in the wall th กรรชัย กำเนิดพลอย
42 Q5924066 en Hryb be Грыб
43 Q5998342 en Iliopoulos el Ηλιόπουλος
44 Q6003183 en Imamović sr Имамовић
45 Q6019992 en Indian Celery ml പരകത,ടത]തഡ
46 Q6121458 en Jadhav hi जाधव
47 Q6125443 en Jakova sq Jakova (kthjellim)
48 Q6154752 en Janič sr Јанич
49 Q6154981 en Jankulovski sr Јанкуловски
50 Q6158472 en Japanese cruiser Suzuya ja 鈴谷