select * from data where sn='thermostat0' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
18596015 thermostat0 temp 11.06 1553011802 Tue 19 03 2019 17:10:02
18596002 thermostat0 temp 11.06 1553011782 Tue 19 03 2019 17:09:42
18595993 thermostat0 temp 11.06 1553011762 Tue 19 03 2019 17:09:22
18595980 thermostat0 temp 11.06 1553011743 Tue 19 03 2019 17:09:03

Wed Jun 26 10:08:02 2019 by walley