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
Tue Jul 14 04:52:51 2020 by walley