SELECT
        mm.member_id
        ,mm.password
        ,mm.sts
        ,mm.number_of_failed_logins
    FROM 
        member AS mm
    WHERE
        mm.sts = 30
        AND mm.email = 'ascot_demo1@ascot.co.jp'