

各个平台都做清空因计算价格失败的队列。

SELECT
'mercadolibre',
a.SiteCode,
a.FailureReason,
COUNT( 1 ) AS '失败次数统计'
FROM
ap_autopublish_mercadolibre_queue a
WHERE
a.CustomerId = 1
and a.MarketId=70
AND `Status` = 'failure'
AND a.Time >'2023-01-31 00:00:00'
AND a.Time <'2023-02-02 00:00:00'
GROUP BY
a.SiteCode,
a.FailureReason
ORDER BY COUNT(1)DESC

