淘宝加密发顺丰解密异常

select orderCode,msg,dateTime,o.flag,O.fopl,O.lpco,O.crdt,O.eddt,n.rena
from actionMessage a —接口日志表
left join obma o on a.orderCode=o.biid —销售订单主表
left join noin n on a.orderCode=n.biid —收件信息
—left join bilp i on a.orderCode=i.biid and i.numb=1 —销售订单物流单号表
WHERE a.dateTime>’2021-08-20 00:00:00’and A.msg like ‘%淘系Oaid解密失败%’and o.flag not in (‘100’,’31’)and n.rena like ‘%*%’

select * from bilp where biid IN (‘DPO210819043960’)

OAID查询：
select oaid,* from noin where biid IN (‘DPO210820015462’,’DPO210820015461’)