User:Akkakk/issues/disambiguation conflicts
< User:Akkakk | issues
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 | 鈴谷 |