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;