恢复数据
SELECT
DISTINCT sku ,CategoryId
FROM
p_deletecategory
WHERE
MarketId = 70
AND CategoryId!='0'
AND CategoryId LIKE 'CBT%'
AND Sku IN (
SELECT DISTINCT
a.Sku
FROM
p_market_product a
INNER JOIN p_market_product_review b ON a.CustomerId = b.CustomerId
AND a.MarketId = b.MarketId
AND a.Sku = b.Sku
WHERE
a.CustomerId = 1
AND a.MarketId = 70
AND a.CategoryId NOT LIKE 'CBT%'
AND b.ReviewStatus = 3
)
-- 已恢复分类
UPDATE p_market_product s1
join (SELECT
DISTINCT sku ,CategoryId
FROM
p_deletecategory
WHERE
MarketId = 70
AND CategoryId!='0'
AND CategoryId LIKE 'CBT%'
AND Sku IN (
SELECT DISTINCT
a.Sku
FROM
p_market_product a
INNER JOIN p_market_product_review b ON a.CustomerId = b.CustomerId
AND a.MarketId = b.MarketId
AND a.Sku = b.Sku
WHERE
a.CustomerId = 1
AND a.MarketId = 70
AND a.CategoryId NOT LIKE 'CBT%'
AND b.ReviewStatus = 3
)
) s2
ON s1.Sku = s2.Sku
SET s1.CategoryId = s2.CategoryId
WHERE s1.CustomerId = 1 AND s1.MarketId = 70