例子：

-- 查询渠道SKU是否进入队列 SELECT * FROM pp_phoenixplan_kogan_queue WHERE CustomerId=1 AND MarketId=81 AND StrategyId=6242 AND SellerSku="NX2I105838ZR1CTUZ8";

-- 查询渠道SKU是否满足策略条件 SELECT a.SellerSku,a.PublishTime,a.OnlineStatus,b.LogisticsAttribute,b.StrongPlug,b.StrongPlugItem FROM m_kogan_listing a LEFT JOIN p_product b ON a.CustomerId=b.CustomerId AND a.sku=b.sku WHERE a.CustomerId=1 AND a.SellerSku="NX2I105838ZR1CTUZ8";

-- 查询渠道SKU映射的系统SKU 是否是变体 SELECT sku,IsVariant,IsMainVariant,ParentId FROM p_product WHERE CustomerId=1 AND sku="6414152";

-- 查询系统sku对应的主变体SKU SELECT * FROM p_product WHERE ParentId="MU6414554";

-- 查询主变体SKU的审核状态
SELECT a.sku,b.sku,b.ReviewStatus,a.CategoryId FROM p_market_product a
LEFT JOIN p_market_product_review b ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.SiteCode=b.SiteCode AND a.sku=b.sku
WHERE a.CustomerId=1 AND a.MarketId=81 AND a.SiteCode="AU" AND a.sku="6414002";

漏

--  查询总销量
SELECT SellerSku,SUM(Sales) FROM m_kogan_sale_year_summary WHERE CustomerId=1 AND MarketId=81 AND SellerSku="NX2I105838ZR1CTUZ8" GROUP BY  SellerSku ;

自动调价策略例子

-- 查询渠道SKU是否进入队列
SELECT * FROM pp_phoenixplan_kogan_queue WHERE CustomerId=1 AND MarketId=81 AND StrategyId=3084 AND SellerSku="B4J1195900NNTO4OFE";

-- 查询渠道SKU是否满足策略条件
SELECT a.sku,a.SellerSku,a.PublishTime,a.OnlineStatus,b.LogisticsAttribute,b.StrongPlug,b.StrongPlugItem
FROM m_kogan_listing a 
LEFT JOIN p_product b ON a.CustomerId=b.CustomerId AND a.sku=b.sku
WHERE a.CustomerId=1 AND a.SellerSku="B4J1195900NNTO4OFE";

--  查询总销量
SELECT SellerSku,SUM(Sales) FROM m_kogan_sale_year_summary WHERE CustomerId=1 AND MarketId=81 AND SellerSku="B4J1195900NNTO4OFE" GROUP BY  SellerSku ;

-- 查询渠道SKU映射的系统SKU 是否是变体
SELECT sku,IsVariant,IsMainVariant,ParentId FROM p_product WHERE CustomerId=1 AND sku="9909072";

-- 查询主变体SKU的审核状态
SELECT a.sku,b.sku,b.ReviewStatus,a.CategoryId FROM p_market_product a
LEFT JOIN p_market_product_review b ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.SiteCode=b.SiteCode AND a.sku=b.sku
WHERE a.CustomerId=1 AND a.MarketId=81 AND a.SiteCode="AU" AND a.sku="9909072";