[前置条件]
系统正常
[重现步骤]
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 补货日志
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 = 57
AND a.time > '2024-01-16 14:00:00'
AND a.StrategyId =470

[重现规律]
必现
[实际结果]
店铺ID:6230,同步到100多条数据,执行出989条队列
[期望结果]
只执行半托listing的自动补货策略
