select * from data where sn='thermostat0' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
29378645 thermostat0 ip 192.168.2.126 1576443868 Sun 15 12 2019 22:04:28
29378630 thermostat0 ip 192.168.2.126 1576443846 Sun 15 12 2019 22:04:06
29378615 thermostat0 ip 192.168.2.126 1576443825 Sun 15 12 2019 22:03:45
29378603 thermostat0 ip 192.168.2.126 1576443804 Sun 15 12 2019 22:03:24

Sun Dec 15 22:04:36 2019 by walley