select * from data where sn='max1' and pq='voltype' order by id desc limit 4
id
sn
ts
pq
value
systemts
3997586
max1
1497630500
voltype
VOLT
1497630500
Fri 16 06 2017 18:28:20
Tue Jul 14 04:50:51 2020 by walley