Ladsgroup added a comment.

FYI. This query which is pretty fast can give you total number of forms and senses but it won't stay fast in future:

MariaDB [wikidatawiki_p]> select pp_propname, SUM(pp_value) as total_number from page_props where pp_propname in ('wbl-senses', 'wbl-forms') group by pp_propname;
+-------------+--------------+
| pp_propname | total_number |
+-------------+--------------+
| wbl-forms   |        26390 |
| wbl-senses  |         3620 |
+-------------+--------------+
2 rows in set (0.12 sec)

TASK DETAIL
https://phabricator.wikimedia.org/T191424

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

To: Ladsgroup
Cc: Ladsgroup, JAllemandou, Esc3300, gerritbot, Addshore, GoranSMilovanovic, Aklapper, Lydia_Pintscher, CucyNoiD, Nandana, NebulousIris, Mringgaard, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, Jonas, Wikidata-bugs, aude, Darkdadaah, Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to