select * from data where sn='meteo1' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
2336660 meteo1 temp 23.12 1489416524 Mon 13 03 2017 15:48:44
2336645 meteo1 temp 23.19 1489416502 Mon 13 03 2017 15:48:22
2336640 meteo1 temp 23.19 1489416481 Mon 13 03 2017 15:48:01
2336625 meteo1 temp 23.19 1489416459 Mon 13 03 2017 15:47:39

Mon Mar 25 06:18:01 2019 by walley