daniel added a comment. |
count for mgwiktionary:
mysql:wikiadmin@10.64.16.18 [cognate_wiktionary]> SELECT count(*) 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 = 8120841685256385134 JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key and q.cgpa_namespace = 0 and q.cgpa_site = p.cgpa_site WHERE a.cgti_raw_key < b.cgti_raw_key; +----------+ | count(*) | +----------+ | 146 | +----------+ 1 row in set (43.34 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