select * from data where sn='thermostat0' and pq='tin' order by id desc limit 4
idsntspqvaluesystemts
24380507 thermostat0 tin 22.31 1566433301 Thu 22 08 2019 02:21:41
24380489 thermostat0 tin 22.31 1566433272 Thu 22 08 2019 02:21:12
24380472 thermostat0 tin 22.31 1566433243 Thu 22 08 2019 02:20:43
24380456 thermostat0 tin 22.31 1566433215 Thu 22 08 2019 02:20:15

Thu Aug 22 02:22:05 2019 by walley