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.
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 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 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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud