select * from data where sn='meteo2' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
34847499 meteo2 temp 25.56 1586424929 Thu 09 04 2020 11:35:29
34847498 meteo2 temp 25.69 1586424329 Thu 09 04 2020 11:25:29
34847497 meteo2 temp 25.94 1586423729 Thu 09 04 2020 11:15:29
34847496 meteo2 temp 26.31 1586423128 Thu 09 04 2020 11:05:28

Tue Jul 14 04:57:00 2020 by walley