select * from data where sn='max1' and pq='rawtype' order by id desc limit 4
id
sn
ts
pq
value
systemts
3797596
max1
rawtype
VOLT
1496046507
Mon 29 05 2017 10:28:27
Mon Oct 21 04:15:01 2019 by walley