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 https://en.wikipedia.org/wiki/Wikipedia:User_access_levels#Autoconfirmed_and_confirmed_users .
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