--- (sub_module gesetzt):
-DELETE FROM custom_variables
-WHERE (config_id IN (SELECT id FROM custom_variable_configs WHERE module = 'IC'))
- AND (sub_module = 'orderitems')
- AND (trans_id NOT IN (SELECT id FROM orderitems));
-
-DELETE FROM custom_variables
-WHERE (config_id IN (SELECT id FROM custom_variable_configs WHERE module = 'IC'))
- AND (sub_module = 'delivery_order_items')
- AND (trans_id NOT IN (SELECT id FROM delivery_order_items));
-
-DELETE FROM custom_variables
-WHERE (config_id IN (SELECT id FROM custom_variable_configs WHERE module = 'IC'))
- AND (sub_module = 'invoice')
- AND (trans_id NOT IN (SELECT id FROM invoice));
+-- (cv.sub_module gesetzt):
+LEFT JOIN orderitems oi ON (
+ (cfg.module = 'IC')
+ AND (cv.sub_module = 'orderitems')
+ AND (cv.trans_id = oi.id))
+
+LEFT JOIN delivery_order_items doi ON (
+ (cfg.module = 'IC')
+ AND (cv.sub_module = 'delivery_order_items')
+ AND (cv.trans_id = doi.id))
+
+LEFT JOIN invoice i ON (
+ (cfg.module = 'IC')
+ AND (cv.sub_module = 'invoice')
+ AND (cv.trans_id = i.id))