Projekt

Allgemein

Profil

Herunterladen (669 Bytes)

Fehler #410 » delete_empty_shipto_cvars_ignored.sql

Bernd Bleßmann, 05.12.2019 12:16

 
DELETE FROM shipto
WHERE shiptoname = '' AND shiptodepartment_1 = '' AND shiptodepartment_2 = ''
AND shiptostreet = '' AND shiptozipcode = '' AND shiptocity = ''
AND shiptocountry = '' AND shiptocontact = '' AND shiptophone = ''
AND shiptofax = '' AND shiptoemail = '' AND shiptogln = ''
AND module != 'CT'
AND NOT EXISTS ( SELECT id FROM oe WHERE oe.shipto_id = shipto.shipto_id
UNION SELECT id FROM delivery_orders WHERE delivery_orders.shipto_id = shipto.shipto_id
UNION SELECT id FROM ar WHERE ar.shipto_id = shipto.shipto_id);

-- CVars ignored!
(2-2/2)