\n
Menu
Filtrez
m_50210
m_50215
m_50211
SELECT DISTINCT svac.*
							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 
                                        OR 
                                        shop_item_has_category.item_no = shop_view_active_item.parent_item_group_no
                                    )
							    )
							  
                                            LEFT JOIN shop_item_attribute_links_ext sial ON (
                                                    sial.company = 'DESOI'
                                                AND	sial.shop_code = 'B2B'
                                                AND sial.no = shop_view_active_item.item_no
                                                AND (sial.language_code = 'FRA' OR sial.language_code = '')
                                            )

                                RIGHT JOIN shop_view_active_item svac 
                                ON svac.item_no = shop_view_active_item.item_no
                                    AND svac.company = shop_view_active_item.company 
                                    AND svac.shop_code = shop_view_active_item.shop_code 
                                    AND svac.language_code = shop_view_active_item.language_code
                                
							  WHERE (shop_item_has_category.category_line_no = 158828)
							  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'
							 
                                            AND
                                                    ( ( sial.attribute_code='ZUB-IGMG' AND sial.value_option = 'zub-misch'))
                                                AND sial.shop_code = 'B2B'
                                                AND (
                                                        (
                                                            sial.type = 0
                                                        AND sial.company = 'DESOI'
                                                        )
                                                    OR (
                                                            sial.company IS NULL
                                                        AND sial.type IS NULL
                                                        )
                                                ) GROUP BY shop_view_active_item.item_no  HAVING COUNT(DISTINCT sial.attribute_code) = 1

Principe de fonctionnement Têtes de mélange

Avec les têtes de mélange à 2 composants, les composants A et B sont amenés ensemble peu avant le mélangeur en treillis statique et mélangés dans le mélangeur statique en treillis. (Fig. 1) Grâce aux deux clapets anti-retour, le matériau ne retourne pas dans les tuyaux de matériau. La section de mélange peut être adaptée au matériau d'injection au moyen de différents tubes de mélange et du nombre de mélangeurs à treillis statiques.

Têtes de mélange 2C

Têtes de mélange 3C

Le raccord de rinçage intégré nettoie la tête de mélange complètement, y compris les vannes.


à l'étage