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 = 0
        AND cu.customer_group = '19116000'
        AND cu.customer_code IN (
            SELECT customer_code FROM reading_group_customer
            WHERE customer_group = '19116000' AND any_code = '19116-1'
        )
    ORDER BY 
        cu.customer_id