1 drop table if exists adjustment;
2 drop table if exists counter;
3 create table adjustment (timestamp datetime, value int);
4 create table counter (timestamp datetime, value int);
6 insert into adjustment values ('2016-01-07 00:00:00', 10);
7 insert into counter values ('2016-01-07 00:00:01', 5);
8 insert into counter values ('2016-01-07 00:00:02', 10);
9 insert into counter values ('2016-01-07 00:00:03', 15);
10 insert into adjustment values ('2016-01-07 00:00:04', 30);
11 insert into counter values ('2016-01-07 00:00:05', 0);
12 insert into counter values ('2016-01-07 00:00:06', 5);
13 insert into counter values ('2016-01-07 00:00:07', 10);
15 select timestamp, value+adj as value from
16 (select c.timestamp timestamp, c.value value,
17 (select value from adjustment a
18 where a.timestamp <= c.timestamp
19 order by timestamp desc limit 1) adj from counter c