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 = 158554)
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'
Die eingegebenen Zugangsdaten sind nicht korrekt. Bitte versuchen Sie es erneut.
Kunde werden
Sie haben noch keinen Online-Zugang? Fordern Sie hier Ihre Zugangsdaten an.
Artikel zum
Warenkorb hinzufügen
Alle gewählten Artikel
zum Warenkorb hinzufügen
Artikel aus Warenkorb
entfernen
Merkliste
Merkliste
Artikel nicht auf Lager
Vorbestellung möglich
Artikel in geringer
Menge auf Lager
Artikel in ausreichender
Menge auf Lager
Artikel in Zulauf
Der Artikel ist in einer laufenden
Aktion enthalten
IMPORTANT INFORMATION:
HOW TO ORDER SPARE AND WEAR PARTS
It is extremely important to state the SERIAL NUMBER when ordering spare parts! This is the only way we can ensure that the correct parts are supplied.
The serial number can be entered in the ‘Comment/Serial number’ field during the ordering process. You will find the number on the type plate on the frame of the injection device.
Our range includes a large number of wear and spare parts. If you still cannot find what you are looking for, please do not hesitate to contact us via the contact form, by e-mail or by telephone. Our team will be happy to help you find the right part.
