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

SELECT
id,customerId,sku,
p.productState,p.min_sale_num,p.productGroupSku,p.qlength,p.qwidth,p.qheight,p.qlength+p.qwidth+p.qheight '三边和',p.weight,
(p.qlength*p.qwidth*p.qheight)/10 '体积重',(p.qlength*p.qwidth*p.qheight)/10/p.weight*1000 '抛率',p.plug_relate_type '强电',p.with_battery '产品物流属性'
FROM 
( SELECT
rp.id,
rp.product_name AS productName,
rp.is_group AS isGroup,
rp.customer_id AS customerId,
rp.product_state AS productState,
rp.sku AS sku,
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.brand_id AS brandId,
rp.net_weight AS netWeight,
rp.gross_weight AS grossWeight,
rp.pack_weight AS packWeight,
rp.unit_name AS unitName,
rp.unit_num AS unitNum,
rp.product_color AS productColor,
rp.product_size AS productSize,
rp.is_main_group_sku AS isMainGroupSku,
rp.product_property AS tort,
rp.pack_length AS packLength,
rp.pack_width AS packWidth,
rp.pack_height AS packHeight,
rp.length AS length,
rp.width AS width,
rp.height AS height,
rp.plug_relate_type AS plug_relate_type,
rp.with_battery AS with_battery,
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 qlength,
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 qwidth,
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 qheight,
CASE
WHEN rp.pack_weight > 0 THEN
rp.pack_weight ELSE rp.gross_weight 
END AS weight,
rp.min_sale_num 
FROM
rb_product rp
JOIN 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 
AND rp.sku IN ('17136654', '17100935', '17012693', '17209163', '17128451', '17104396', '17104700', '17071563', '17098341', '17152101', '17148485', '17148501', '17137150', '17088156', '17126394', '17057503', '17011545', '16955615', '17148442', '17142350', '17064006', '17054647', '17098240', '17056620', '17152046', '17071119', '17039988', '17056131', '17103766', '17126395', '17184029', '17135618', '17209116', '17145804', '17139606', '17055827', '17118285', '17098281', '17055299', '17117947', '17079667', '16955539', '17056672', '17156512', '17073023', '17161905', '17118274', '17032401', '17093933', '17104180', '17079708', '17056654', '17006715', '17091530', '17088192', '17149801', '17126396', '17077087', '17095855', '17103979', '17042238', '16955610', '17176798', '17153013', '17142687', '17116911', '17087840', '17055398', '17128340', '17056661', '17006856')


) p 
WHERE NOT EXISTS (
SELECT 1 FROM rb_product_no_sale rpns WHERE p.customerId=rpns.customer_id AND p.sku=rpns.sku AND rpns.platform_id=45)
--  AND p.productState IN ( 0,1,5 )#产品状态
-- AND  (1<=p.min_sale_num  AND  p.min_sale_num<=500)#起批量
-- AND (6<=p.qlength AND 6<=p.qwidth and 6<=p.qheight )  AND  ( p.qlength<=30 AND p.qwidth<=30 and p.qheight<=30)#单边长
-- AND  (1<=(p.qlength + p.qwidth + p.qheight)  AND  (p.qlength + p.qwidth + p.qheight)<=1000)#三边和
-- AND  (0.001<=p.weight   AND  p.weight<=50000)#包裹重
-- AND  (0.01<= (p.qlength*p.qwidth*p.qheight)/10  AND (p.qlength*p.qwidth*p.qheight)/10<=1000)#体积重
-- AND  (0.01<= (p.qlength*p.qwidth*p.qheight)/10/p.weight*1000   AND  (p.qlength*p.qwidth*p.qheight)/10/p.weight*1000<=1000)#抛率
-- AND  p.plug_relate_type not in (0,1,2,3,4,5)#强电插头
-- AND  p.with_battery IN (12)#产品物流属性

ORDER BY id DESC LIMIT 500

变体刊登 Is Primary Variant  Variant Group ID校验

失败的返还刊登额度