Addshore added a comment.
In T208425#5992641 <https://phabricator.wikimedia.org/T208425#5992641>, @Mahir256 wrote: > I have a query, https://quarry.wmflabs.org/query/18763, that returns label/description/alias statistics for a set of languages (also mentioned in T197161#4300061 <https://phabricator.wikimedia.org/T197161#4300061>). This was derived from a query used by @Pasleim to update this table <https://www.wikidata.org/wiki/User:Pasleim/Language_statistics_for_items> (which worked until the end of May) and its South Asian counterpart <https://www.wikidata.org/wiki/Wikidata:WikiProject_India/India_statistics> (which worked up until wb_terms updates got turned off). I tried to rewrite the Quarry query to use the new databases (https://quarry.wmflabs.org/query/41692), but running this has not yet succeeded, either using Quarry or directly on tools-login. I am not sure whether this rewritten query can be simplified beyond what's written at present, so I was hoping there might be a better way of obtaining these statistics via SQL that does not presently time out. The best I can suggest with the new tables for quarry is https://quarry.wmflabs.org/query/43212 You'll have to run a query per language in order to not be killed. Ideally we will calculate these numbers on the #analytics <https://phabricator.wikimedia.org/tag/analytics/> cluster and publish them somewhere they can just be queried as we used to do. Probably needs T154601: Grafana: "wikidata-datamodel-terms" doesn't update anymore <https://phabricator.wikimedia.org/T154601> to be fixed, thn each day you could grab these numbers in under a second! TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Mahir256, Pasleim, Jony, Lea_Lacroix_WMDE, Bugreporter, Ladsgroup, JAllemandou, ArielGlenn, jcrespo, Joe, Gehel, alaa_wmde, Marostegui, Jdforrester-WMF, Addshore, Aklapper, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
