问题描述:
高销数据筛选错误
数据:
'17346850','14979181','14493428','12907219'
打标表中筛选不到相同SKU,不同ASIN大于等于2的Listing,相同SKU只有一条Listing
db.MarkListing_FBA.find({
SiteCode:'US',
ListingStatus:0,
"SaleDayInfo.SaleDay30":{$gte:3},
"ArrivedTimeInfo.FirstMSKU":{$lt:ISODate("2025-07-27T00:00:00.000+08:00")},
SKU:{$in:['17346850','14979181','14493428','12907219']}
}) .sort({})

高销新品Listing表中,标记为高销
SELECT * FROM `t_price_limit_fba_listing` where sku in (
'17346850','14979181','14493428','12907219'
) and labelType = 1 ORDER BY sku DESC

