Hi RhinosF1,

There are a ton of relevant example queries here too: https://wikitech.wikimedia.org/wiki/Help:MySQL_queries#Example_queries

Also, my HostBot sampling query uses may of the conditions that you're looking to filter by, and may be useful as a template for that reason: https://quarry.wmflabs.org/query/30143

If by "confirmed" you mean "autoconfirmed", that's probably something you'll need to filter for manually; I don't believe there's a flag for this in any of the dbs, because it's an arbitrary Enwiki-only pseudogroup.

Finally, I *think* that putting /*SLOW_OK*/ at the top of your query will prevent timeout for longer-running queries, so you may want to do that.

Hope that helps,

Jonathan

On Thu, Mar 14, 2019 at 2:23 AM RhinosF1 Wikipedia <rhinosf1@gmail.com> wrote:

Hi,
Could someone advise how I could do Quarry queries on user activity?
I'd like to monitor the following on en-wiki:
All for unblocked humans
-Number of active, confirmed editors (Done,
https://quarry.wmflabs.org/query/34268)
-Number of active editors with only 1 edit
-Number of active editors with only 1 mainspace edit
-Number of active non-conformirmed Editors

Definitions:
Active : 1 edit in last 30 days
Human : No bot flag
Confirmed : 4 days / 10 edits
_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics