```
SELECT
p.id,p.customerId,p.spu,p.sku,p.class_id,p.is_group 组合产品,p.is_main_group_sku 产品类型,p.product_state 产品状态,p.product_property 侵权风险,p.brand_id 产品品牌,p.with_battery 物流属性,p.plug_relate_type 强电插头,p.min_sale_num 起批量,p.length,p.width,p.height,
(p.length*p.width*p.height)/6000 AS 体积重,
(p.length*p.width*p.height)/6000/p.pack_weight*1000 AS 抛率
FROM (SELECT
rp.id,
rp.customer_id AS customerId,
rp.sku AS sku,
rp.product_group_sku AS spu,
rp.product_group_sku AS productGroupSku,
rp.last_supplier_price AS lastSupplierPrice,
rp.last_buy_price AS lastBuyPrice,
rp.market_price AS marketPrice,
rp.last_buy_ship_fee AS lastBuyShipFee,
rp.add_time AS addTime,
rp.class_id,
rp.is_group,
rp.is_main_group_sku,
rp.product_state,
rp.product_property,
rp.brand_id,
rp.with_battery,
rp.plug_relate_type ,
rp.min_sale_num ,
CASE WHEN (rp.pack_length > 0 AND rp.pack_width > 0 AND rp.pack_height > 0) THEN rp.pack_length ELSE rp.length END AS length,
CASE WHEN (rp.pack_length > 0 AND rp.pack_width > 0 AND rp.pack_height > 0) THEN rp.pack_width ELSE rp.width END AS width,
CASE WHEN (rp.pack_length > 0 AND rp.pack_width > 0 AND rp.pack_height > 0 )THEN rp.pack_height ELSE rp.height END AS height ,
CASE WHEN rp.pack_weight=0 THEN rp.gross_weight ELSE rp.pack_weight END AS pack_weight
FROM`zhcxkj-center-product`.rb_product rp
JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id AND rpa.sku = rp.sku AND rpa.check_status = 1
WHERE rp.customer_id = 1) p
WHERE p.class_id IN ( 4711 ) -- erp分类
AND p.is_group=0 -- 是否组合产品
AND p.is_main_group_sku=0 -- 是否多变体
AND p.product_state IN (0) -- 产品状态
AND p.product_property=1 -- 侵权风险
-- AND p.plug_relate_type not in (0,1,2,3,4,5) -- 强电插头
-- AND rp.with_battery =12 -- 产品物流属性
-- AND p.min_sale_num BETWEEN 10 AND 10
-- AND (p.length*p.width*p.height)/6000 BETWEEN 0.150 AND 0.160
-- AND p.length BETWEEN 1 AND 10
-- AND p.width BETWEEN 1 AND 10
-- AND p.height BETWEEN 1 AND 10
-- AND (p.length+p.width+p.height) BETWEEN 1 AND 10
-- AND p.pack_weight BETWEEN 1 AND 10
-- AND ((SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) BETWEEN 0 AND 2
-- OR (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) IS NULL)
AND p.brand_id =0 -- 品牌产品
ORDER BY p.addTime DESC
```
例如SKU 15025379 应该是变体，但是目前是通过is_main_group_sku=0 查询出来的