[步骤]

-- 速卖通指定失败原因查询
SELECT
  'aliexpress',
  a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
d.OrderSourceName AS 来源渠道,
  a.FailureReason
FROM
  ap_autopublish_aliexpress_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
  a.CustomerId = 1 
  and a.MarketId=57
  AND `Status` = 'failure' 
 AND a.Time >'2023-07-08 00:00:00'
 AND a.Time <'2023-07-09 00:00:00'
 AND a.FailureReason LIKE'%在线和审核中的商品数量加合要小于店铺最大商品数量限制，请调整%'

[结果]

[期望]