select * from data where sn='thermostat0' and pq='tin' order by id desc limit 4
idsntspqvaluesystemts
27201208 thermostat0 tin 19.00 1571624327 Mon 21 10 2019 04:18:47
27201202 thermostat0 tin 19.00 1571624299 Mon 21 10 2019 04:18:19
27201193 thermostat0 tin 19.00 1571624270 Mon 21 10 2019 04:17:50
27201187 thermostat0 tin 19.00 1571624242 Mon 21 10 2019 04:17:22

Mon Oct 21 04:18:58 2019 by walley