SELECT
        cu.customer_id
        ,cu.customer_group
        ,cu.customer_code
        ,cu.customer_name1
        ,cu.customer_name2
        ,cu.status
        ,cu.note1
    FROM 
        customer cu
    WHERE 
        cu.status <> -1
        AND cu.customer_group = '19116000'
    ORDER BY 
        cu.customer_id