select * from data where sn='thermostat0' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
72415382 thermostat0 ip 192.168.2.66 1714165843 Fri 26 04 2024 23:10:43
72415379 thermostat0 ip 192.168.2.66 1714165823 Fri 26 04 2024 23:10:23
72415371 thermostat0 ip 192.168.2.66 1714165802 Fri 26 04 2024 23:10:02
72415370 thermostat0 ip 192.168.2.66 1714165781 Fri 26 04 2024 23:09:41

Fri Apr 26 23:10:50 2024 by walley