select * from data where sn='thermostat0' and pq='tin' order by id desc limit 4
idsntspqvaluesystemts
29378679 thermostat0 tin 15.44 1576443910 Sun 15 12 2019 22:05:10
29378666 thermostat0 tin 15.44 1576443889 Sun 15 12 2019 22:04:49
29378644 thermostat0 tin 15.44 1576443868 Sun 15 12 2019 22:04:28
29378633 thermostat0 tin 15.44 1576443846 Sun 15 12 2019 22:04:06

Sun Dec 15 22:05:28 2019 by walley