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 = 101290000
                    
                  )
               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 = 101290000
                    
                  )
               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] => 70450
)
 
MKN Heizkörper für Wärmebrücken | gastrotiger
Nach Gerät suchen Dropdown-Icon

Heizkörper für Wärmebrücken - MKN

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 = 101290000
                    
                  )
               AND
                 shop_item_has_category.company              = 'gastrotiger' AND
                 shop_item_has_category.shop_code            = 'B2C' AND
                 shop_item_has_category.category_shop_code   = 'B2C' 
                  LEFT JOIN shop_attribute_link ON (shop_attribute_link.no = shop_view_active_item.item_no AND shop_attribute_link.shop_code = shop_view_active_item.shop_code)
                WHERE  shop_item_has_category.category_language_code = 'DEU' 
                  
                   AND( shop_attribute_link.attribute_code='WSGERAETEFILTER' AND shop_attribute_link.value_option = '70450') 
                 GROUP BY shop_attribute_link.id
                  HAVING COUNT(DISTINCT shop_attribute_link.id) = 1
                
testocache  
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 = 101290000
                    
                  )
               AND
                 shop_item_has_category.company              = 'gastrotiger' AND
                 shop_item_has_category.shop_code            = 'B2C' AND
                 shop_item_has_category.category_shop_code   = 'B2C' 
                  LEFT JOIN shop_attribute_link ON (shop_attribute_link.no = shop_view_active_item.item_no AND shop_attribute_link.shop_code = shop_view_active_item.shop_code)
                WHERE  shop_item_has_category.category_language_code = 'DEU' 
                  
                   AND( shop_attribute_link.attribute_code='WSGERAETEFILTER' AND shop_attribute_link.value_option = '70450') 
                 GROUP BY shop_attribute_link.id
                  HAVING COUNT(DISTINCT shop_attribute_link.id) = 1
                

Artikelbild Heizkörper 600W 230V HK 1 L 37... 124,84 €*104,91 € nettoinkl. MwSt. zzgl. Versandkostensofort verfügbar
Zum Produkt
  • Leistung: 600 W
  • Spannung: 230 V
  • Länge: 375 mm
  • Anwendung: Wärmebrücke
Artikelbild Heizkörper 1000W 230V HK 1 L 6... 123,93 €*104,14 € nettoinkl. MwSt. zzgl. Versandkostensofort verfügbar
Zum Produkt
  • Leistung: 1.000 W
  • Spannung: 230 V
  • Länge: 627 mm
  • Anwendung: Wärmebrücke
Artikelbild Heizkörper 1400W 230V HK 1 L 8... 175,43 €*147,42 € nettoinkl. MwSt. zzgl. Versandkostensofort verfügbar
Zum Produkt
  • Leistung: 1.400 W
  • Spannung: 230 V
  • Länge: 875 mm
  • Anwendung: Wärmebrücke
Artikelbild Heizkörper 1800W 230V HK 1 L 1... 34,26 €*28,79 € nettoinkl. MwSt. zzgl. Versandkostensofort verfügbar
Zum Produkt
  • Leistung: 1.800 W
  • Spannung: 230 V
  • Länge: 1.125 mm
  • Anwendung: Wärmebrücke

Top-Hersteller der Kategorie