深圳智汇创想科技有限公司

SELECT
tal.source_id,
tal.msku,
tal.sku 
FROM
t_amazon_listing tal
LEFT JOIN t_amz_product_performance_dim tappd ON tappd.source_id = tal.source_id 
AND tappd.msku = tal.msku 
WHERE
tal.source_id IN (
16549
) 
AND tal.msku IS NOT NULL 
AND tappd.msku IS NULL
and tal.is_deleted = 0
and tal.sku is not null and tal.sku != ''

and tal.del_status = 0

可用>0 产品表现没有记录

SELECT * FROM t_amz_product_performance_dim where msku ='News-ND-ND-ANT' and source_id=16549;

SELECT *   FROM t_amazon_listing_6 where  source_id=16549 and msku ='News-ND-ND-ANT' ;

productPerformanceDataCleanHandler

SELECT * FROM t_amz_product_performance_dim where msku ='News-ND-ND-ANT' and source_id=16549;

mysql