time draft - Quarry

SQL

use hewiki_p;
set @startdate = "2015-11-11";
set @stopdate  = "2015-11-17";
set @summer = -3;
set @newstartdate = date_add(concat(@startdate, " 00:00:00"), interval @summer hour);
set @newstopdate  = date_add(concat(@stopdate, " 00:00:00"), interval @summer hour);
select @newstartdate, @newstopdate;
select rev_timestamp from revision
where timediff(@newstopdate, rev_timestamp) > 0
and timediff(@newstartdate, rev_timestamp) < 0
order by rev_timestamp desc
limit 10;
#elect rev_timestamp from revision
#here datediff("2015-11-10 14:52:59", rev_timestamp) > 0
#nd datediff("2015-11-05 14:52:59", rev_timestamp) < 0
#imit 10;

#SET time_zone ='+03:00';
#select concat(substring("20151110145259", 1, 4), '-', substring("20151110145259", 5, 2), '-', substring("20151110145259", 7, 2), ' ',
#substring("20151110145259", 9, 2), ':', substring("20151110145259", 11, 2));
#select rev_timestamp, convert_tz(rev_timestamp,'GMT','MET') from revision limit 10;
#ELECT now(), DATE_ADD(20030104002633, INTERVAL 3 HOUR)
#where datediff("2015-11-10 14:52:59", rev_timestamp) > 0
#and datediff("2015-11-05 14:52:59", rev_timestamp) < 0
#order by rev_timestamp desc
#limit 10
SQL

Checking query status...
