1、 将 美客多/allegro 的已审核通过且无类目的数据，改审核状态为待审核（ReviewStatus=2）
SELECT
COUNT(1)
FROM
p_market_product_review a
RIGHT JOIN
p_market_product b
ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.Sku=b.Sku
WHERE
a.CustomerId=1
AND a.MarketId IN (70,67)
AND a.ReviewStatus=3
AND (b.CategoryId IS NULL OR b.CategoryId ='')
2、 将 allegro 的已审核通过且最末级类目为'other'的审核数据，改审核状态为待审核（ReviewStatus=2）
SELECT
a.*
FROM
p_market_product_review a
INNER JOIN
p_market_product b
ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.Sku=b.Sku
INNER JOIN m_productcategory c
on b.MarketId=c.marketid AND b.categoryid=c.categoryid
WHERE
a.CustomerId=1
AND a.MarketId=67
AND a.ReviewStatus=3
AND c.NameEn='other'
SELECT
COUNT(1)
FROM
p_market_product_review a
RIGHT JOIN
p_market_product b
ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.Sku=b.Sku
WHERE
a.CustomerId=1
AND a.MarketId IN (70,67)
AND a.ReviewStatus=3
AND (b.CategoryId IS NULL OR b.CategoryId ='')
2、 将 allegro 的已审核通过且最末级类目为'other'的审核数据，改审核状态为待审核（ReviewStatus=2）
SELECT
a.*
FROM
p_market_product_review a
INNER JOIN
p_market_product b
ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.Sku=b.Sku
INNER JOIN m_productcategory c
on b.MarketId=c.marketid AND b.categoryid=c.categoryid
WHERE
a.CustomerId=1
AND a.MarketId=67
AND a.ReviewStatus=3
AND c.NameEn='other'
---------------
先的把数据发给业务核对后 再改状态
