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

帮忙清量美客多数据，执行SQL顺序如下：

-- 删除 Listing 无效的数据

DELETE
FROM m_mercadolibre_listing
WHERE Id IN (SELECT t1.Id
FROM m_mercadolibre_del_listing_site AS t0
LEFT JOIN m_mercadolibre_listing AS t1
ON t0.CustomerId = t1.CustomerId AND t0.OrderSourceId = t1.OrderSourceId AND
t0.ProductId = t1.ProductId);

-- 删除 Sub 无效的数据
DELETE
FROM m_mercadolibre_listing_sub
WHERE Id IN (SELECT t1.Id
FROM m_mercadolibre_del_listing_site AS t0
LEFT JOIN m_mercadolibre_listing_sub AS t1
ON t0.CustomerId = t1.CustomerId AND t0.OrderSourceId = t1.OrderSourceId AND
t0.ProductId = t1.ProductId);


-- 删除 Listing Attribute 无效的数据
DELETE
FROM m_mercadolibre_listing_attribute
WHERE Id IN (SELECT t1.Id
FROM m_mercadolibre_del_listing_site AS t0
LEFT JOIN m_mercadolibre_listing_attribute AS t1
ON t0.CustomerId = t1.CustomerId AND t0.OrderSourceId = t1.OrderSourceId AND
t0.ProductId = t1.ProductId);

-- 删除 Site 无效的数据
DELETE
FROM m_mercadolibre_listing_site
WHERE Id IN (SELECT Id
FROM m_mercadolibre_del_listing_site);