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 = 106060000
                    
                  )
               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 = 106060000
                    
                  )
               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] => 74701
)
 
Everest Platinen | gastrotiger
Nach Gerät suchen Dropdown-Icon

Platinen - Everest

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

Artikelbild Platine für Fleischwolf TG12/T... 121,46 €*102,07 € nettoinkl. MwSt. zzgl. Versandkostenverfügbar in 3-4 Wochen
Zum Produkt
  • Anwendung: für Fleischwolf
  • passend für Gerät: TG12/TG22
  • passend für Hersteller: EVEREST
Artikelbild Platine Käsereibe GS-TF-ST00 L... 269,77 €*226,70 € nettoinkl. MwSt. zzgl. Versandkostenverfügbar in 9-10 Wochen
Zum Produkt
  • Länge: 104 mm
  • Breite: 104 mm
  • Anwendung: Käsereibe
  • passend für Gerät: GS-TF-ST00

Top-Hersteller der Kategorie