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
Sun Jul 21 04:11:57 2019 by walley