select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
27201356 thermostat0 tout 16.69 1571624897 Mon 21 10 2019 04:28:17
27201355 thermostat0 ip 192.168.2.126 1571624897 Mon 21 10 2019 04:28:17
27201354 thermostat0 tin 19.00 1571624897 Mon 21 10 2019 04:28:17
27201350 thermostat0 tin 19.00 1571624869 Mon 21 10 2019 04:27:49

Mon Oct 21 04:28:36 2019 by walley