select * from data where sn='thermostat0' order by id desc limit 4
idsntspqvaluesystemts
71943709 thermostat0 tout 19.12 1711727431 Fri 29 03 2024 16:50:31
71943708 thermostat0 tin 24.31 1711727431 Fri 29 03 2024 16:50:31
71943707 thermostat0 ip 192.168.2.66 1711727431 Fri 29 03 2024 16:50:31
71943706 thermostat0 relay 0 1711727430 Fri 29 03 2024 16:50:30

Fri Mar 29 16:50:32 2024 by walley