Draft to delete

Fork of Rolling number of edits (7 days) by a sample of users on cswiki by Blahma

This query is marked as a draft This query has been published by Blahma.

Bots excluded. When forking, please adapt wiki, dates and user names at the top. If applicable, fix timezone (currently set to CEST for the whole year).

SQL

use cswiki_p;
set @begin = '20150101000000', @end = '20160101000000';
set @u1 = 1350, @u2 = 14001, @u3 = 263456, @u4 = 278695, @u5 = 219100; # 'Tomáš Páv', 'Sokoljan', 'Rosenfeld~cswiki', 'Fanoušek kopané', 'Galgo'
select date(date_add(rev_timestamp, interval 2 hour)) as date, count(*) as edits from revision where rev_user in (@u1, @u2, @u3, @u4, @u5) and rev_timestamp between 0+date_sub(@begin, interval 2 hour) and 0+date_sub(date_sub(@end, interval 2 hour), interval 1 second) group by date order by date;

SQL

Checking query status...