【正式环境】【测试线上bug】埋词策略设置多个埋词销量条件，总销量和15天销量分别设置为：1-9999, 0-0，查询到获取到的listing总销量=0 也被获取到，不符合过滤条件

埋词策略销量条件设置：

获取到总销量=0 的listing，并不符合埋词策略设置的销量条件：

145523780185
166525018880
166525018879
166525018885
166525018904
134869314359
145523780678
166525018955
166525018961
145523781047
134869314447
145523781226

SQL参考：

select
t.*
, el.QuantitySold 
from (
select ebq.OrderSourceId
, ebq.ProductID
, date_format(ebq.LastModificationTime, "%Y-%m-%d")
, ebq.LastModificationTime
, ebq.StrategyId
from m_ebay_buriedwords_queue ebq
-- use index(idx_status_date_type)
where 
   ebq.date in (20240109,20240110)
and ebq.LastModificationTime >= 20240109
and ebq.LastModificationTime < 20240110
and ebq.status=1
and ebq.type=202
and ebq.StrategyId=68
group by ebq.OrderSourceId
, ebq.ProductID
, ebq.LastModificationTime
, ebq.StrategyId
) t inner join m_ebay_listing el on t.OrderSourceId=el.OrderSourceID and t.ProductID=el.ProductID
where el.QuantitySold=0 and el.ProductId in ('145523780185',
'166525018880',
'166525018879',
'166525018885',
'166525018904',
'134869314359',
'145523780678',
'166525018955',
'166525018961',
'145523781047',
'134869314447',
'145523781226')

[步骤]

[结果]

[期望]