[] select R1.*,R2.recive_flg from (select *,REPLACE(cphone,'-','') as cellphone,if(country_num='' or country_num is null,82,country_num) as country_code from lead where email='2113d09abf8a8367c20c8d1fe21947f6' or md5(email)='2113d09abf8a8367c20c8d1fe21947f6') R1 left join idgk_mailer.email_list R2 on R2.email=R1.email