Replicas browser and optimizer
fawiki users with interface edits
This query is marked as a draft
This query has been published
use fawiki_p; SELECT /*SLOW OK */ DATE ( CONCAT ( YEAR(rev_timestamp), "-", MONTH(rev_timestamp), "-", DAY(rev_timestamp) ) ) AS DAY, rev_user_text,COUNT(rev_timestamp) AS revisions FROM revision join user_groups on rev_user = ug_user WHERE ug_group = 'sysop' and rev_timestamp > '20170821000000' GROUP BY DAY,rev_user_text order by DAY desc
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