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
Mon Oct 21 04:14:13 2019 by walley