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

​