
        SELECT 
            customer.id, 
            customer.code, 
            customer.name, 
            customer.contact, 
            customer.phone, 
            customer.other_phone, 
            customer.fax, 
            customer.email, 
            customer.bill_to_address, 
            customer.bill_to_apt, 
            customer.bill_to_city, 
            customer.bill_to_state, 
            customer.bill_to_zip, 
            customer.ship_to_address, 
            customer.ship_to_apt, 
            customer.ship_to_city, 
            customer.ship_to_state, 
            customer.ship_to_zip, 
            '' AS check_shipping_address, 

            customer.description, 
            customer.avatar 
        FROM customer 
        WHERE customer.deleted = '0' 
        AND customer.id = '1' ;