需求背景：MX站点禁售一次性塑料产品，由于删除条件与通用的删除服务不符，临时做一次删除处理

需求实现：

1.筛选一次性塑料产品相关SKU，排除FBAlisting及其自发货，剩余所有的listing都做删除

SELECT a.OrderSourceName,a.OrderSourceSKU,a.ASINorItemID,a.SKU,a.BusinessTeamName,a.BusinessUserName,a.AddAdminName,a.IsOffShelf,a.IsDelete FROM aml_amazon_product_base a

INNER JOIN zhcxkj_dw_bi.tmp_sku_dbs b on a.SKU=b.SKU
LEFT JOIN aml_amazon_product_base c on c.OrderSourceCountry = a.OrderSourceCountry
AND c.ASINorItemID = a.ASINorItemID
AND c.IsFBA = 1
WHERE a.IsFBA=0 and a.OrderSourceCountry='MX' and c.OrderSourceSKUID is null

2.提交到删除队列删除，需要二次验证是否成功删除