策略94

sql

···

SELECT
rp.id,
rp.customer_id AS customerId,
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.product_state,
rp.product_property
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 
AND rp.class_id IN ( 4711 ) 
AND rp.is_group=0
AND rp.is_main_group_sku=1
AND rp.product_state=0
AND rp.product_property=1
AND rp.brand_id !=0
ORDER BY rp.add_time DESC

···

结果

实际队列把不是品牌的产品生成了队列