Your missing a "group by" clause. Try grouping by the page_namespace.
Hereโs the correct query.
<https://quarry.wmflabs.org/query/41407>
Cyberpower678
English Wikipedia Account Creation Team
English Wikipedia Administrator
Global User Renamer
On Jan 16, 2020, at 16:53, Maciej Jaros
<egil(a)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 <https://quarry.wmflabs.org/query/41072>
Longer query, but correct results:
https://quarry.wmflabs.org/query/24267 <https://quarry.wmflabs.org/query/24267>
Is this a bug or a feature? ๐
Cheers,
Nux.
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud