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 <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > -- Jonathan T. Morgan Senior Design Researcher Wikimedia Foundation User:Jmorgan (WMF) <https://meta.wikimedia.org/wiki/User:Jmorgan_(WMF)>
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
