select * from data where sn='ds1' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
27201727 ds1 temp 17.44 1571626311 Mon 21 10 2019 04:51:51
27201721 ds1 temp 17.44 1571626289 Mon 21 10 2019 04:51:29
27201718 ds1 temp 17.44 1571626268 Mon 21 10 2019 04:51:08
27201712 ds1 temp 17.44 1571626246 Mon 21 10 2019 04:50:46

Mon Oct 21 04:52:22 2019 by walley