Index: /mods/wpsg_mod_productvariants.class.php
===================================================================
--- /mods/wpsg_mod_productvariants.class.php	(revision 7227)
+++ /mods/wpsg_mod_productvariants.class.php	(revision 7228)
@@ -2256,12 +2256,14 @@
             $arFields[10]['fields']['wpsg_mod_productvariants_varname'] = __('Varianten Name', 'wpsg');
             $arFields[10]['fields']['wpsg_mod_productvariants_varanr'] = __('Varianten Artikelnummer', 'wpsg');
-         
-            $arVariant = $this->db->fetchAssoc("
+	
+			$arVariant = $this->db->fetchAssoc("
                 SELECT
-                    `id`, `name`, `product_id`
+                    V.`id`, V.`name`, V.`product_id`
                 FROM
-                    ".WPSG_TBL_VARIANTS." 
+                    ".WPSG_TBL_VARIANTS." AS V
+                    	LEFT JOIN `".WPSG_TBL_PRODUCTS."` AS P ON (P.`id` = V.`product_id`)
                 WHERE
-                    `deleted` != '1'
+                    V.`deleted` != '1' AND
+                    (V.`product_id` <= 0 OR P.`deleted` = '0')
             ");