select user_id, member_state, email_verified_p from cc_users where email = lower(:email)