[步骤]
1.创建策略，设置销量条件如图，执行[结果]
1.有符合条件的listing但是没有过滤出来[期望]
1.有符合条件的listing，创建优惠券
SELECT
t1.estimate_sale_num,
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.estimate_sale_num BETWEEN 1 AND 30
问题已解决