Hello, Questions about quarry querying are best left on the Quarry talk page here: https://www.mediawiki.org/wiki/Talk:Quarry
And here's some example pseudo-code that looks at active editors over a rolling window: https://github.com/wikimedia/analytics-wikimetrics/blob/master/wikimetrics/metrics/rolling_active_editor.py#L24 It's not quite what you need, but it should help get you thinking about what's involved. For example, looking at the archive and revision tables together, aggregating, etc. For your namespace filters, you'd have to join to the page table as well, and look at page_namespace. There are also lots of other similar questions you can search for on the Quarry talk page.
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
