1 -- @tag: customer_remove_empty_additional_billing_addresses
2 -- @description: Leere »zusätzliche Rechnungsadressen« entfernen
3 -- @depends: customer_additional_billing_addresses
5 FROM additional_billing_addresses
6 WHERE (coalesce(name, '') = '')
7 AND (coalesce(department_1, '') = '')
8 AND (coalesce(department_2, '') = '')
9 AND (coalesce(contact, '') = '')
10 AND (coalesce(street, '') = '')
11 AND (coalesce(zipcode, '') = '')
12 AND (coalesce(city, '') = '')
13 AND (coalesce(country, '') = '')
14 AND (coalesce(email, '') = '')
15 AND (coalesce(phone, '') = '')
16 AND (coalesce(fax, '') = '');