Per a conversation on #wikimedia-tech Special:Statistics no longer works [1], Would it be possible to get an alternate query?
Topic on Talk:Quarry
I see you already have a few examples like https://quarry.wmflabs.org/query/35057, and I'm wondering what else you'd like help with. One thing I can suggest is that you try to format your queries so they can be more easily read. For example, try this style (which I'm a little too obsessive about, I admit, but it's good)
SELECT COUNT(DISTINCT rc_user) FROM recentchanges_userindex JOIN user ON (rc_user = user_id) LEFT JOIN ipblocks ON (rc_user = ipb_user) WHERE rc_user != 0 AND rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%S') AND rc_type = 0 AND rc_bot = 0 AND ipb_id IS NULL AND (user_registration IS NULL OR user_registration < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY), '%Y%m%d%H%i%S')) AND user_editcount >= 1
And btw, you can write that user registration clause as:
(coalesce(user_registration, '2000') < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY), '%Y%m%d%H%i%S'))
Ah, It wasn't me that made them! Can't remember who! - I was looking for one that just did a number of editors with a logged edit or action in last 30 days @Milimetric (WMF)