select * from data where sn='thermostat0' and pq='relay' order by id desc limit 4
idsntspqvaluesystemts
72398938 thermostat0 relay 0 1714081522 Thu 25 04 2024 23:45:22
72398932 thermostat0 relay 0 1714081501 Thu 25 04 2024 23:45:01
72398928 thermostat0 relay 0 1714081481 Thu 25 04 2024 23:44:41
72398925 thermostat0 relay 0 1714081455 Thu 25 04 2024 23:44:15

Thu Apr 25 23:45:37 2024 by walley