select * from data where sn='thermostat0' and pq='tin' order by id desc limit 4
idsntspqvaluesystemts
39737128 thermostat0 tin 20.62 1594695516 Tue 14 07 2020 04:58:36
39737112 thermostat0 tin 20.62 1594695495 Tue 14 07 2020 04:58:15
39737096 thermostat0 tin 20.62 1594695474 Tue 14 07 2020 04:57:54
39737084 thermostat0 tin 20.62 1594695452 Tue 14 07 2020 04:57:32

Tue Jul 14 04:58:54 2020 by walley