select * from data where sn='222222' and pq='soc' order by id desc limit 4
id
sn
ts
pq
value
systemts
84031902
222222
soc
99
1785931469
Wed 05 08 2026 14:04:29
84031901
222222
soc
99
1785931453
Wed 05 08 2026 14:04:13
84031898
222222
soc
99
1785931264
Wed 05 08 2026 14:01:04
Sat Aug 15 21:28:07 2026 by walley