On Jan 16, 2020, at 16:53, Maciej Jaros <egil@wp.pl> wrote:

Hi.

I'm doing a secret project 😉 for a presentation. I want to count edits per namespace up until certain date. There are about ~200 users so not that much, but too many to do via edit counter...

Using revision_actor_temp I get results much(!) faster, but I get a different namespace (2 instead of 0).
https://quarry.wmflabs.org/query/41072

Longer query, but correct results:
https://quarry.wmflabs.org/query/24267

Is this a bug or a feature? 😉

Cheers,
Nux.

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud