zzz

SELECT DISTINCT kc.`Nick` FROM kd_customer kc
WHERE ((kc.UserType!='0')) AND ((kc.FirstPayTime>=DATE_ADD(CURDATE(),INTERVAL -45 DAY) AND kc.FirstPayTime<DATE_ADD(CURDATE(),INTERVAL 1 DAY))) AND ((kc.IsMarketingBlack='0')) AND ((kc.IsCallBackBlack='0')) AND ((kc.IsUnSubScribe='0')) AND ((kc.MemberGrade IN ('general','senior','vip','king')))

转载于:https://www.cnblogs.com/zhiqian/p/6677017.html