Mineral material
More InformationsFilter
Filter
m_50215
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 = 70000) 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'
Log in
The entered access data are not correct. Please try again.
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
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