tidb mysql 查询_tidb、mysql连写两个字段名相同值不同的条件查不出数据

一、现象

今天想写个python脚步拼装sql，拼装好的sql条件中advertiser_id连续出现两次，其值不同，然后去tidb查询不正常，如下

# 这些写显示adv241418839104数据

select advertiser_id

from r_day_stat_ad_effect

where bucket_id='total' and advertiser_id in ('adv241418839104','adv2516121497984') and order_id!='total' and ad_id!='total' and mid='total' and slot_id='total' and app_id='total' and publisher_id='total' and country_code='total'

and day>20200128 and day<=20200227 and advertiser_id not in ('adv2516121497984') and test=0 group by advertiser_id;

# 没数据，即不显示adv241418839104 也不显示adv241418839104

select advertiser_id

from r_day_stat_ad_effect

where bucket_id='total' and advertiser_id in ('adv241418839104') and order_id!='total' a