select * from data where sn='12250' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
27202217 12250 temp 24.31 1571628302 Mon 21 10 2019 05:25:02
27202140 12250 temp 24.31 1571628002 Mon 21 10 2019 05:20:02
27202064 12250 temp 24.31 1571627702 Mon 21 10 2019 05:15:02
27201984 12250 temp 24.31 1571627402 Mon 21 10 2019 05:10:02

Mon Oct 21 05:24:54 2019 by walley