Menü
StartseitePoints forts

Points forts

Découvrez ici nos produits populaires et éprouvés !

N'hésitez pas à commander en ligne dès maintenant - les meilleures solutions vous attendent !
Si vous avez des questions sur les produits ou leurs applications, nous nous ferons un plaisir de vous conseiller à tout moment.
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 = 159201)
							  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'
nach oben