[步骤]
-- shopee
SELECT
a.OrderSourceId,
b.OrderSourceName,
a.BusinessType,
a.StrategyId,
a.LastJobNo,
a.LastStatus,
a.LastFailureLog,
a.LastDurations,
a.LastDate,
a.LastTime,
a.LastIp
FROM
sys_autopublishdata a
LEFT JOIN sys_ordersource b
on a.CustomerID=b.CustomerID AND a.OrderSourceID=b.OrderSourceID
WHERE
a.CustomerID = 1
AND a.BusinessType LIKE '%shopeeV2AutoPublish%'
AND b.IsActive=1
AND b.IsDelete=0
AND b.OrderSourceName = 'Shopee-Z19040-PH/24/kev'
AND a.StrategyId in (select Id from ap_autopublish_strategy WHERE CustomerId = 1 and MarketId = 97 and IsEnabled = 1 and IsDeleted = 0)
[结果]
有设置相应的额度限制，服务执行有拦截，但还是超过当日最大刊登量限制,3个策略当天都有执行成功的数据
78136
78282
78284
[期望]
查明超出每日最大刊登量：50的原因
