[步骤]
17859 Z2UFZE01MRVBQ25I3560SZ8
SELECT
a1.OrderSourceID,
a1.OrderSourceSKU,
a1.Sku,
a1.CheckStatus,
a1.PushType,
a1.AddTime,
a1.PredictedProbability,
a1.IsPredictedOk FROM RB_Amazon_AutoFba_Check a1
WHERE
a1.PushType IN ( 0, 4 )
AND a1.CheckStatus IN ( 0, 4 )
AND DATEDIFF( DAY, a1.AddTime, GETDATE( ) ) > 30 AND a1.OrderSourceID=17859
独立账号
推送类型为待转导入和二单转入
审核状态为未审核和暂不处理
fba审核表的添加时间距今>30天
销量预测结果为达标



30天销量>2

未限制备货

[结果]
[期望]
asin 为空