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