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(a)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(a)lists.wikimedia.org
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)>