delete from intermediate.users where intermediate.users.email not in ( SELECT email FROM ultrax.common_member where emailstatus = 0 and avatarstatus = 0 and email NOT LIKE '%163%' and email NOT LIKE '%qq%' and email NOT LIKE '%126%' and email NOT LIKE '%gmail%' and email not like '%sina%' and email not like '%sohu%' and email not like '%21cn%');
select * from intermediate.users where intermediate.users.email in ( SELECT email FROM ultrax.common_member where emailstatus = 0 and avatarstatus = 0 and email NOT LIKE '%163%' and email NOT LIKE '%qq%' and email NOT LIKE '%126%' and email not like '%sina%' and email not like '%sohu%' and email not like '%21cn%' and email not like '%zzjp%' and email not like '%szql26%');
delete from intermediate.users where intermediate.users.email in ( SELECT email FROM ultrax.common_member where emailstatus = 0 and avatarstatus = 0 and email NOT LIKE '%163%' and email NOT LIKE '%qq%' and email NOT LIKE '%126%' and email not like '%sina%' and email not like '%sohu%' and email not like '%21cn%' and email not like '%zzjp%' and email not like '%szql26%');