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 = 145000)
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'
Add Item to
Shopping Basket
Add all selected Items
to Shopping Basket
Remove Item from Shopping Basket
Add item to favorites
Remove Item from Favorites
Stock Outage
Make a Preorder
Insufficient Stock
Item well stocked
Article in delivery
This item is part of a current campain
GENERAL NOTES
When using the materials, adhere to adequate protective measures, if necessary, wear safety goggles, protective gloves, ear protection, etc.! We guarantee the quality of our materials within the scope of our terms and conditions of sale and delivery. In order to reduce the risk of errors, restrictive indications are stated as well. Naturally, it is not possible to cover completely all possible current and future application and special cases. Specifications that can be assumed to be known by experts have been omitted. The user cannot be released from further enquiries in case of uncertanties, independent testing on site and professional processing.
