17541

14727

10265

17541

11977

[步骤]

[结果]

[期望]

select count(*) from (
select a.source_id  from t_amazon_listing_extra a where a.source_id not in (
select source_id from t_amazon_listing_extra where is_buy_box != 0 group by source_id )
group by a.source_id 
) t;

select * from rb_order_source where id in
(select a.source_id  from t_amazon_listing_extra a where a.source_id not in (
select source_id from t_amazon_listing_extra where is_buy_box != 0 group by source_id )
group by a.source_id) and is_active = 1 and channel_platform_status = 0 ;