select * from data where sn='thermostat0' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
39736234 thermostat0 ip 192.168.1.101 1594694188 Tue 14 07 2020 04:36:28
39736220 thermostat0 ip 192.168.1.101 1594694167 Tue 14 07 2020 04:36:07
39736208 thermostat0 ip 192.168.1.101 1594694145 Tue 14 07 2020 04:35:45
39736196 thermostat0 ip 192.168.1.101 1594694124 Tue 14 07 2020 04:35:24

Tue Jul 14 04:36:35 2020 by walley