daniel added a comment. |
Checked for enwiktionary, found 6 pairs of pages:
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 = 8711873510529828948 -> JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key -> and q.cgpa_namespace = 0 and q.cgpa_site = 8711873510529828948 -> WHERE a.cgti_raw_key < b.cgti_raw_key -> LIMIT 10; +---------------------------+-----------------------------+ | cgti_raw | cgti_raw | +---------------------------+-----------------------------+ | дев'ятнадцять | дев’ятнадцять | | ... | … | | '_' | ’_’ | | ’ | ' | | lu’um | lu'um | | ni' | ni’ | +---------------------------+-----------------------------+ 6 rows in set (39.45 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