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 = 104060000
                    
                  )
               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 = 104060000
                    
                  )
               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] => 79115
)
 
Palux Magnetschalter | gastrotiger
Nach Gerät suchen Dropdown-Icon

Magnetschalter - Palux

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 = 104060000
                    
                  )
               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 = '79115') 
                 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 = 104060000
                    
                  )
               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 = '79115') 
                 GROUP BY shop_attribute_link.id
                  HAVING COUNT(DISTINCT shop_attribute_link.id) = 1
                

Artikelbild Magnetschalter L 36mm B 13mm 1... 24,35 €*20,46 € nettoinkl. MwSt. zzgl. Versandkostenverfügbar in 5-6 Wochen
Zum Produkt
  • Spannung: 250 V
  • Schaltleistung: 1 A
  • Anschluss: Kabel
  • Kabellänge: 980 mm
Artikelbild Magnetschalter Gewinde M12x1 1... 58,60 €*49,24 € nettoinkl. MwSt. zzgl. Versandkostensofort verfügbar
Zum Produkt
  • Spannung: 250 V
  • Schaltleistung: 3 A
  • Gewindegröße: M12x1
  • Anschluss: Kabel
Artikelbild Magnetschalter Anschluss Kabel... nicht mehr lieferbar
  • Anschluss: Kabel 1000mm
  • Länge: 25,4 mm
  • Einbaudurchmesser: 5,22 mm

Top-Hersteller der Kategorie