Your missing a "group by" clause. Try grouping by the page_namespace.
Here’s the correct query.
English Wikipedia Account Creation Team
English Wikipedia Administrator
Global User Renamer
On Jan 16, 2020, at 16:53, Maciej Jaros
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
Using revision_actor_temp I get results much(!) faster, but I get a different namespace
(2 instead of 0).
Longer query, but correct results:
Is this a bug or a feature? 😉
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)