SELECT member_name,preferred_name,email,city,date_of_birth,created_at FROM member WHERE DATE(created_at) <= SUBDATE(CURRENT_DATE(),1) AND DATE(created_at) >= SUBDATE(CURRENT_DATE(),INTERVAL 1 WEEK);