select * from data where sn='thermostat0' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
81480084 thermostat0 ip 192.168.2.110 1770975390 Fri 13 02 2026 10:36:30
81480077 thermostat0 ip 192.168.2.110 1770975369 Fri 13 02 2026 10:36:09
81480073 thermostat0 ip 192.168.2.110 1770975348 Fri 13 02 2026 10:35:48
81480071 thermostat0 ip 192.168.2.110 1770975326 Fri 13 02 2026 10:35:26

Fri Feb 13 10:36:36 2026 by walley