问题描述：

销量等级，日销量表同步订单有缺失

ERP表两个订单，日销量表只有一个订单

ERPSQL :

SELECT r2.OrderSourceName, r1.* FROM RB_Report_OrderSourceSKUDay r1 JOIN RB_OrderSource r2 ON r1.OrderSourceID = r2.id WHERE  r2.OrderSourceName not like 'TEMU%' AND r2.OrderSourceName not like 'Ozon%'  AND r2.OrderSourceName not like 'Mercadolibre%' AND r2.OrderSourceName not like 'Aliexpress%' AND r2.OrderSourceName not like 'Shein%' AND r2.OrderSourceName not like 'Allegro%' AND r2.OrderSourceName not like 'Shopee%' AND r2.OrderSourceName not like 'Tik Tok%' AND r2.OrderSourceName not like 'TEMU%' AND r2.OrderSourceName not like 'Ozon%'  AND r2.OrderSourceName not like 'Mercadolibre%'  AND r2.OrderSourceName not like 'Lazada%' AND r2.OrderSourceName not like '直发-Walmart%' AND r2.OrderSourceName not like 'Walmart%'  
AND SalesDay >= '2025-07-07'  
AND r2.OrderSourceCountry = 'AU'
AND SKU IN (
'10116664'
) 

日销量表SQL:

SELECT * FROM p_product_sku_marketsale  WHERE  SCOPE = 'AU' AND  MarketId  IN (1,2)  AND SKU IN (
'10116664'
)