select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
29410923 thermostat0 relay 0 1576491826 Mon 16 12 2019 11:23:46
29410922 thermostat0 tout 14.44 1576491826 Mon 16 12 2019 11:23:46
29410921 thermostat0 ip 192.168.2.126 1576491826 Mon 16 12 2019 11:23:46
29410920 thermostat0 tin 14.00 1576491826 Mon 16 12 2019 11:23:46

Mon Dec 16 11:24:06 2019 by walley