[步骤]
-- Kogan指定失败原因查询
SELECT
'Kogan',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
-- COUNT( 1 ) AS '失败次数统计'
FROM
ap_autopublish_Kogan_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=81
AND `Status` = 'failure'
AND a.Time >'2023-07-25 11:00:00'
-- AND a.Time <'2023-07-18 00:00:00'
AND a.FailureReason LIKE'%Time limit exceeded%'
[结果]
需要标记，但没有标记，重跑时会漏
[期望]
正常标记
SELECT
'Kogan',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
-- COUNT( 1 ) AS '失败次数统计'
FROM
ap_autopublish_Kogan_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=81
AND `Status` = 'failure'
AND a.Time >'2023-07-25 11:00:00'
-- AND a.Time <'2023-07-18 00:00:00'
AND a.FailureReason LIKE'%Unable to process image with url%'