select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
21719380 thermostat0 tout 20.69 1561536003 Wed 26 06 2019 10:00:03
21719379 thermostat0 ip 192.168.2.126 1561536003 Wed 26 06 2019 10:00:03
21719378 thermostat0 tin 23.75 1561536003 Wed 26 06 2019 10:00:03
21719364 thermostat0 tout 20.69 1561535975 Wed 26 06 2019 09:59:35

Wed Jun 26 10:00:04 2019 by walley