[Wikidata-bugs] [Maniphest] [Commented On] T165311: Investigate title normalization clashes

[daniel]

daniel added a comment.

For frwiktionary:

mysql:wikiadmin@10.64.16.18 [cognate_wiktionary]> SELECT a.cgti_raw, b.cgti_raw FROM cognate_titles as a   JOIN cognate_titles as b ON a.cgti_normalized_key = b.cgti_normalized_key   JOIN cognate_pages as p ON p.cgpa_title = a.cgti_raw_key      and p.cgpa_namespace = 0 and p.cgpa_site = 2097444195020099748   JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key      and q.cgpa_namespace = 0 and q.cgpa_site = 2097444195020099748 WHERE a.cgti_raw_key < b.cgti_raw_key;
+---------------------------+-------------------------+
| cgti_raw                  | cgti_raw                |
+---------------------------+-------------------------+
| Palazzolo_sull’Oglio      | Palazzolo_sull'Oglio    |
| Urago_d'Oglio             | Urago_d’Oglio           |
| ...                       | …                       |
| Vezza_d’Oglio             | Vezza_d'Oglio           |
| sms’en                    | sms'en                  |
| 'e                        | ’e                      |
| 'o                        | ’o                      |
| Monteleone_d'Orvieto      | Monteleone_d’Orvieto    |
| ’                         | '                       |
| Quinzano_d'Oglio          | Quinzano_d’Oglio        |
| o’                        | o'                      |
| ’a                        | 'a                      |
| Robecco_d'Oglio           | Robecco_d’Oglio         |
| Scandolara_Ripa_d’Oglio   | Scandolara_Ripa_d'Oglio |
+---------------------------+-------------------------+
14 rows in set (37.42 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T165311

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: daniel
Cc: Addshore, Lydia_Pintscher, Lea_Lacroix_WMDE, Aklapper, daniel, GoranSMilovanovic, QZanden, Thibaut120094, Izno, Wikidata-bugs, aude, GPHemsley, Darkdadaah, Mbch331, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs