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 May 21 20:39:05 2019 by walley