select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
24380805 thermostat0 tin 22.31 1566433813 Thu 22 08 2019 02:30:13
24380804 thermostat0 tout 20.06 1566433813 Thu 22 08 2019 02:30:13
24380803 thermostat0 ip 192.168.2.126 1566433813 Thu 22 08 2019 02:30:13
24380782 thermostat0 tout 20.06 1566433785 Thu 22 08 2019 02:29:45

Thu Aug 22 02:30:20 2019 by walley