[步骤]
SELECT
'allegro',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
FROM
ap_autopublish_allegro_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=67
AND `Status` = 'failure'
AND a.Time >'2023-07-12 00:00:00'
-- AND a.Time <'2023-02-15 00:00:00'
AND a.FailureReason LIKE'%图片少于%'

[结果]
DelType 为null,这个错误,应该标记为1[期望]
标记为1
经查,有数据 如下: