Your missing a "group by" clause. Try grouping by the page_namespace.
Hereโs the correct query. https://quarry.wmflabs.org/query/41407 <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 <e...@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@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
