testoitemq 
        SELECT DISTINCT shop_view_active_item.item_no FROM shop_view_active_item 
          JOIN shop_item_has_category  ON shop_item_has_category.item_no = shop_view_active_item.item_no 
              AND ( 
                    shop_item_has_category.category_line_no = 102000000
                     OR shop_item_has_category.category_line_no IN (102010000,
102030000,
102040000,
102050000,
102060000,
102070000,
102080000,
102090000,
102100000,
102120000,
102140000,
102150000,
102170000,
102190000,
102200000,
102220000)
                  )
               AND
                 shop_item_has_category.company              = 'gastrotiger' AND
                 shop_item_has_category.shop_code            = 'B2C' AND
                 shop_item_has_category.category_shop_code   = 'B2C' 
                 
                WHERE  shop_item_has_category.category_language_code = 'DEU' 
                  
                  
                 
                 
                
testoitemq 
        SELECT DISTINCT shop_view_active_item.item_no FROM shop_view_active_item 
          JOIN shop_item_has_category  ON shop_item_has_category.item_no = shop_view_active_item.item_no 
              AND ( 
                    shop_item_has_category.category_line_no = 102000000
                     OR shop_item_has_category.category_line_no IN (102010000,
102030000,
102040000,
102050000,
102060000,
102070000,
102080000,
102090000,
102100000,
102120000,
102140000,
102150000,
102170000,
102190000,
102200000,
102220000)
                  )
               AND
                 shop_item_has_category.company              = 'gastrotiger' AND
                 shop_item_has_category.shop_code            = 'B2C' AND
                 shop_item_has_category.category_shop_code   = 'B2C' 
                 
                WHERE  shop_item_has_category.category_language_code = 'DEU' 
                  
                  
                 
                 
                
testo222 Array
(
    [WSGERAETEFILTER] => 72400
)
 
Bonnet Weitere Heizelemente und Zubehör | gastrotiger
Nach Gerät suchen Dropdown-Icon
Weitere Heizelemente und Zubehör - Bonnet

Weitere Heizelemente und Zubehör - Bonnet

testo222Y 

Es wurden keine Produkte in dieser Kategorie mit diesem Filter gefunden!

Top-Hersteller der Kategorie