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 = 104000000
                     OR shop_item_has_category.category_line_no IN (104010000,
104020000,
104030000,
104040000,
104050000,
104060000,
104070000,
104080000,
104090000,
104100000,
104110000)
                  )
               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 = 104000000
                     OR shop_item_has_category.category_line_no IN (104010000,
104020000,
104030000,
104040000,
104050000,
104060000,
104070000,
104080000,
104090000,
104100000,
104110000)
                  )
               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] => 79521
)
 
Solymac Schaltelemente | gastrotiger
Nach Gerät suchen Dropdown-Icon
Schaltelemente - Solymac

Schaltelemente - Solymac

testo222Y 

Top-Hersteller der Kategorie