Menu
HomepageBESTSELLER

BESTSELLER

Discover our popular and proven products here!

The best solutions are waiting for you!
If you have any questions about the products or their applications, we will be happy to advise you at any time.
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 = 250000)
							  AND shop_view_active_item.language_code = 'ENU'
							  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 = 'ENU'
							  AND shop_item_has_category.category_shop_code = 'B2B'
scroll top