select * from data where sn='meteo1' order by id desc limit 4
idsntspqvaluesystemts
2336662 meteo1 ip 192.168.43.62 1489416524 Mon 13 03 2017 15:48:44
2336661 meteo1 volt 12.90 1489416524 Mon 13 03 2017 15:48:44
2336660 meteo1 temp 23.12 1489416524 Mon 13 03 2017 15:48:44
2336647 meteo1 ip 192.168.43.62 1489416502 Mon 13 03 2017 15:48:22

Mon Mar 25 06:23:34 2019 by walley