\n
Menu
HomepaginaHIGHLIGHTS

HIGHLIGHTS

Entdecken Sie hier unsere beliebten und bewährten Produkte!

Zögern Sie nicht und bestellen Sie jetzt online – die besten Lösungen warten auf Sie!
Bei Fragen zu den Produkten oder deren Anwendungen stehen wir Ihnen jederzeit gerne beratend zur Seite.
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 = 240000)
							  AND shop_view_active_item.language_code = 'DEU'
							  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 = 'DEU'
							  AND shop_item_has_category.category_shop_code = 'B2B'
naar boven