select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
39737701 thermostat0 tin 20.62 1594696360 Tue 14 07 2020 05:12:40
39737700 thermostat0 tout 18.06 1594696360 Tue 14 07 2020 05:12:40
39737699 thermostat0 relay 0 1594696360 Tue 14 07 2020 05:12:40
39737698 thermostat0 ip 192.168.1.101 1594696360 Tue 14 07 2020 05:12:40

Tue Jul 14 05:12:59 2020 by walley