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

[步骤]

1.创建策略，使用旧版本的条件，上架人员

2.执行策略

[结果]

[期望]

2.可以过滤到符合条件的listing

SELECT
t1.id,
t1.sale_price,
t1.country,
t1.source_name,
t1.customer_id,
t1.source_id,
t1.update_time,
t1.msku,
t1.asin,
t1.sku,
la.listing_price,
t1.business_user_id,
t1.business_user_name,
t1.currency,
lepa.rating_star,
pmihr.inv_age_0_to_90_days,
pmihr.inv_age_91_to_180_days,
pmihr.inv_age_181_to_270_days,
pmihr.inv_age_271_to_365_days,
pmihr.inv_age_365_plus_days,
pmihr.inv_age_90_plus_days,
pmihr.inv_age_180_plus_days,
t1.parent_asin,
t1.listing_method,
t1.publish_time,
t1.seller_id,
t1.marketplace_id,
t1.warehouse,
la.discount_start,
la.discount_end,
t1.delivery_type,
t1.quality
FROM
t_amazon_listing_12 t1
LEFT JOIN t_amazon_listing_amount_12 la ON t1.id = la.id
LEFT JOIN plat_manage_inventory_health_report pmihr ON pmihr.order_source_id = t1.source_id 
AND pmihr.sku = t1.msku 
AND pmihr.asin = t1.asin
LEFT JOIN t_amazon_listing_tag_12 lt ON t1.id = lt.listing_id
LEFT JOIN t_amazon_listing_extra_asin_us lea ON lea.marketplace_id = t1.marketplace_id 
AND lea.asin = t1.asin
LEFT JOIN t_amazon_listing_extra_parent_asin_us lepa ON lepa.marketplace_id = t1.marketplace_id 
AND lepa.asin = t1.asin 
AND lepa.asin_type = 0 
WHERE
t1.asin IS NOT NULL 
AND t1.asin != '' 
AND t1.seller_id IS NOT NULL 
AND t1.marketplace_id IS NOT NULL 
AND t1.source_id = 6891 
AND t1.country = 'US' 
AND la.listing_price BETWEEN '1.0000' 
AND '100.0000'
AND t1.listing_person = "魏玉溪"