select * from data where sn='thermostat0' and pq='tout' order by id desc limit 4
idsntspqvaluesystemts
31209241 thermostat0 tout 10.94 1579347780 Sat 18 01 2020 12:43:00
31209226 thermostat0 tout 10.94 1579347716 Sat 18 01 2020 12:41:56
31209220 thermostat0 tout 11.00 1579347695 Sat 18 01 2020 12:41:35
31209212 thermostat0 tout 10.94 1579347674 Sat 18 01 2020 12:41:14

Sat Jan 18 12:43:06 2020 by walley