Menu
Page d'accueilTECHNIQUE D'INJECTIONAppareils d'injection et de mélangePièces de rechange

Pièces de rechange

Filtrez
Filtrez
                        

                                                        

                        
SELECT DISTINCT shop_view_active_item.*
							FROM shop_item_has_category
							  INNER JOIN shop_view_active_item ON (
							    shop_view_active_item.company = shop_item_has_category.company AND 
							    shop_view_active_item.shop_code = shop_item_has_category.shop_code AND 
							    shop_view_active_item.language_code = shop_item_has_category.language_code AND 
                                    ( 
                                      shop_item_has_category.item_no = shop_view_active_item.item_no 
                                    )
							    )
							  
							  WHERE (shop_item_has_category.category_line_no = 158554)
							  AND shop_view_active_item.language_code = 'FRA'
							  AND shop_view_active_item.company = 'DESOI'
							  AND shop_view_active_item.shop_code = 'B2B'
							  AND shop_item_has_category.company = 'DESOI'
							  AND shop_item_has_category.shop_code = 'B2B'
							  AND shop_item_has_category.language_code = 'FRA'
							  AND shop_item_has_category.category_shop_code = 'B2B'
							 

                                        

                    
                    

                        
    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
          
                    
                        
                    

                  
        

        

                
                  


         

        
Page
1234
                    
                     
                    



    

    

    

    
    

    

    

    

    

    


                

                

                                    

            

        

                

        
    

    
    

        

            

                
                à l'étage