SELECT
        mm.member_id
        ,mm.email
        ,mm.password
        ,mm.name
        ,mm.sts
        ,mm.tmp_email
        ,mm.alert_mail_flg
        ,mm.admin_id
        ,mm.customer_group
        ,mm.department_name
        ,mm.tel
        ,mm.any_code
        ,mm.create_time
        ,mm.update_time
        ,mm.delete_time
        ,mm.number_of_failed_logins
        ,mm.delivery_notice
        ,mm.invoice_notice
        ,mm.delivery_reminder
        ,mm.invoice_reminder
        ,mm.reminder_date
    FROM 
        member AS mm
    WHERE
        mm.customer_group = '19116000'
        AND mm.any_code = '19116-1'
        AND mm.sts != 50 
        AND mm.member_id != 0
    ORDER BY 
        mm.member_id