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')))

posted @ 2017-04-07 10:43 Luo Q 阅读(176) 评论(0) 编辑收藏举报