Um unsere Webseite für Sie optimal zu gestalten und fortlaufend verbessern zu können, verwenden wir Cookies. Wenn Sie die Webseite weiter nutzen, gehen wir von Ihrem Einverständnis aus.
Sollten Sie einen Artikel nicht sofort im Shop finden, identifizieren wir diesen gerne für Sie. Foto genügt!
Artikel-Schnellerfassung
Bestellen Sie ganz einfach über die Eingabe der Artikelnummer. Alternativ können Sie bequem eine Artikelliste hochladen und direkt bestellen.
Mein Konto
Die komplette übersicht: Ihre Aufträge und Rechnungen auf einen Blick! Inklusive praktischer Nutzerverwaltung.
Meine Artikel
Hier finden Sie Ihre Einkäufe in einer kompakten und strukturierten übersicht! Außerdem nützliche Angaben wie Kaufdatum und Auftragsnummer.
Ersatzteilfinder
Finden Sie anhand von detaillierten Explosionszeichnungen immer genau das richtige Ersatzteil für Ihre Baugruppe.
Warenkorb
Der Warenkorb mit Ihren Wunschartikeln. Vor dem tatsächlichen Kauf können Sie Ihre Bestellung in Ruhe auf korrekten Inhalt prüfen.
Anmelden
Melden Sie sich über das myBigDutchman-Kundenportal an, um den Shop vollumfänglich zu nutzen.
Noch kein Konto? Jetzt registrieren!
Erstellen Sie Ihr persönliches Kundenkonto im myBigDutchman-Kundenportal.
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`unit`, `e`.`unit_value`, `e`.`preis_per`, `e`.`ampelfarbe`, `e`.`ampelfarbe_value`, `e`.`wbz`, `e`.`article_number`, `e`.`bdstatus`, `e`.`weltpixel_hover_image`, `e`.`rabattfaehig`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='31411'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `search_tmp_6009823b87ee59_04391064` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY `e`.`name` ASC
LIMIT 48name 48
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`ampelfarbe`, `e`.`ampelfarbe_value`, `e`.`article_number`, `e`.`bdstatus`, `e`.`cost`, `e`.`created_at`, `e`.`create_index`, `e`.`description`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image`, `e`.`image_label`, `e`.`kzberechnung`, `e`.`last_update`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`preis_per`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`rabattfaehig`, `e`.`required_options`, `e`.`san`, `e`.`short_description`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`successor`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`technical_data`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`unit`, `e`.`unit_value`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`wbz`, `e`.`weight`, `e`.`weight_type`, `e`.`weltpixel_hover_image`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (((((e.entity_id = '122326') OR (e.entity_id = '11381') OR (e.entity_id = '13840') OR (e.entity_id = '43141') OR (e.entity_id = '26457') OR (e.entity_id = '45132') OR (e.entity_id = '125131') OR (e.entity_id = '77471') OR (e.entity_id = '125128') OR (e.entity_id = '28276') OR (e.entity_id = '20023') OR (e.entity_id = '43016') OR (e.entity_id = '43279') OR (e.entity_id = '11300') OR (e.entity_id = '14586') OR (e.entity_id = '14581') OR (e.entity_id = '12036') OR (e.entity_id = '36837') OR (e.entity_id = '117908') OR (e.entity_id = '14512') OR (e.entity_id = '11996') OR (e.entity_id = '36585') OR (e.entity_id = '45479') OR (e.entity_id = '45474') OR (e.entity_id = '37914') OR (e.entity_id = '37332') OR (e.entity_id = '37880') OR (e.entity_id = '37600') OR (e.entity_id = '119935') OR (e.entity_id = '56542') OR (e.entity_id = '45381') OR (e.entity_id = '74068') OR (e.entity_id = '68300') OR (e.entity_id = '74073') OR (e.entity_id = '42994') OR (e.entity_id = '11453') OR (e.entity_id = '11372') OR (e.entity_id = '11373') OR (e.entity_id = '38250') OR (e.entity_id = '20785') OR (e.entity_id = '25207') OR (e.entity_id = '12006') OR (e.entity_id = '11371') OR (e.entity_id = '38110') OR (e.entity_id = '37840') OR (e.entity_id = '115170') OR (e.entity_id = '47142') OR (e.entity_id = '120185'))))) ORDER BY `e`.`name` ASC
48 SELECT `e`.entity_id, `e`.sku, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='31411'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '73') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '73') AND (`at_name`.`store_id` = 1) where e.visibility in (2, 3, 4) ORDER BY `name` ASC LIMIT 48