SELECT member_id FROM member 
    WHERE sts <> 50 AND email = 'e-tagawa@ascot.co.jp'