daniel added a comment. |
I checked for dewiktionary, and found 45 clashes. All the ones I checked are duplicates and should be fixed. Most seem to be Korean character transcription
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 = -3742436511788647340 JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key and q.cgpa_namespace = 0 and q.cgpa_site = -3742436511788647340 WHERE a.cgti_raw_key < b.cgti_raw_key -> ; +----------------+---------------+ | cgti_raw | cgti_raw | +----------------+---------------+ | p’ya | p'ya | | ch'a | ch’a | | ch’ŏ | ch'ŏ | | ch’o | ch'o | | p'ae | p’ae | | yujach'a | yujach’a | | p'u | p’u | | ch'e | ch’e | | p’yo | p'yo | | p'e | p’e | | ch'ŏl | ch’ŏl | | ch’i | ch'i | | p'urŭda | p’urŭda | | mach’ŏllu | mach'ŏllu | | t’i | t'i | | p'yŏ | p’yŏ | | t’a | t'a | | t'yu | t’yu | | ch’ŏngdong | ch'ŏngdong | | p'yu | p’yu | | ch’ae | ch'ae | | ch'ŏng | ch’ŏng | | p’o | p'o | | ch’ŏldo | ch'ŏldo | | p'wi | p’wi | | ch’ŏlto | ch'ŏlto | | p’ŏ | p'ŏ | | t'u | t’u | | Saint_John’s | Saint_John's | | p'oe | p’oe | | t'o | t’o | | p’a | p'a | | ellibeit'ŏ | ellibeit’ŏ | | t'anso | t’anso | | t'wi | t’wi | | t'ae | t’ae | | t'ŏ | t’ŏ | | p'ŭ | p’ŭ | | p’i | p'i | | ch’u | ch'u | | t'ŭ | t’ŭ | | kimch'i | kimch’i | | t’oe | t'oe | | ch'ŭ | ch’ŭ | | t'e | t’e | +----------------+---------------+ 45 rows in set (36.65 sec)
TASK DETAIL
EMAIL PREFERENCES
To: daniel
Cc: Addshore, Lydia_Pintscher, Lea_Lacroix_WMDE, Aklapper, daniel, GoranSMilovanovic, QZanden, Thibaut120094, Izno, Wikidata-bugs, aude, GPHemsley, Darkdadaah, Mbch331, Krenair
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