Replicas browser and optimizer
This query is marked as a draft
This query has been published
From http://quarry.wmflabs.org/query/4228 by Zache
SELECT avg(uc) AS avg_reviewers_per_day, avg(cc) AS avg_reviews_per_day, floor(avg(cc)/avg(uc)) AS avg_reviews_per_reviewer, floor(d/100) AS dd FROM ( SELECT sum(1) as uc, sum(c) as cc, d from ( SELECT sum(1) as c, log_user_text, floor(log_timestamp/1000000) as d FROM dewiki_p.logging WHERE log_action IN ('approve', 'approve2') group by log_user,d ) AS tmp group by d) AS tmp2 group by dd
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in