select * from data where sn='thermostat0' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
24380134 thermostat0 ip 192.168.2.126 1566432673 Thu 22 08 2019 02:11:13
24380114 thermostat0 ip 192.168.2.126 1566432659 Thu 22 08 2019 02:10:59
24380106 thermostat0 ip 192.168.2.126 1566432610 Thu 22 08 2019 02:10:10
24380069 thermostat0 ip 192.168.2.126 1566432581 Thu 22 08 2019 02:09:41

Thu Aug 22 02:11:38 2019 by walley