[步骤]

    -- 查询shopeeV2自动补货的执行情况
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 = 97
  AND a.StrategyId IN(320,328)
AND a.time > '2022-11-21 00:00:00'
 AND a.SellerSku in(
'DBE235012QAWWN9SV',
'8WTT1546455GOOPRCG',
'68103181925D7UVOQ',
'D3011219CJ0ZGH92',
'091854EHC0UHGF',
'SD195124I46CKB19',
'1430502C2NASSI',
'JB060011I84KRAFT',
'MHZ041506D6C4WH7H',
'175626GOIKF8X2',
'34B0851216E23AZAA'
 )

[结果]

[期望]