[步骤]
SELECT
d.OrderSourceName AS 来源渠道,
a.sku AS 系统SKU,
a.ProductId AS 平台ID,
a.SellerSku AS 渠道SKU,
a.StrategyId AS 执行策略ID,
b.NAME AS 执行策略名称,
a.`Status` AS 执行状态,
a.FailureReason AS 失败原因,
a.Time AS 操作时间,
a.Inventory AS 修改后库存,
a.OriginalInventory AS 原库存,
a.Remark AS 补货日志,
a.Type AS 刊登方式
FROM
pp_replenishment AS a
LEFT JOIN pp_replenishment_strategy AS b ON a.StrategyId = b.id
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
AND a.MarketId = 70
AND a.StrategyId=180 /*加上策略ID走索引*/
AND a.time > '2023-04-16 00:00:00'
AND a.time < '2023-04-19 00:00:00'
AND a.FailureReason LIKE'%At least one policy returned%'
[结果]
At least one policy returned UNAUTHORIZED. 3天报错数据太多[期望]
自动补货正常
