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 = 129843 OR shop_item_has_category.category_line_no = 129843 )
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
Hydraulik nippel
Hydrauliktætnere bruges til injektion indenfor næsten alle områder af boring, tunnelbygning, vandbygning og anlægsarbejde. Disse injektioner bruges generelt til at forbedre tætningen, stabiliseringen, fyldningen eller jordens fysiske egenskaber. Desuden anvendes hydrauliktætnere til prøveinjektioner indenfor måleteknik, forsøg på at presse vandet væk, samt til geologiske undersøgelser i borehullet.
Bodeninjektion mit Blähpackern, Hydraulikpackern, Bohrlochverschlüssen