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 = 115000 OR shop_item_has_category.category_line_no = 115000 )
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'
The entered access data are not correct. Please try again.
Become a customer
You do not have a login? Please contact us.
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
B-Sting®
Насочено допълнително уплътняване на фуги в тръбни тунели
С инжекционната пробивна игла B-Sting® лесно и сигурно се извършват допълнителни уплътнения в уплътнителни фуги на тунели, по-специално на тръбни тунели.
Минимална инвазивност – максимална ефективност.
Wir brauchen Ihr Einverständnis!
Wir benutzen Drittanbieter, um Videoinhalte einzubinden. Diese können persönliche Daten über Ihre Aktivitäten sammeln. Bitte beachten Sie die Details und geben Sie Ihre Einwilligung.
Mehr Informationen
Externe Medien Akzeptieren