SELECT `e`.*, `at_special_price`.`value` AS `special_price`, IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) AS `special_from_date`, IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) AS `special_to_date`, `catalogrule_product_price`.`rule_price`, `catalogrule_product_price`.`latest_start_date` AS `rule_start_date`, `catalogrule_product_price`.`rule_date`, `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` FROM `catalog_product_entity` AS `e`
LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '61') AND (`at_special_price`.`store_id` = 0)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '62') AND `at_special_from_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '62') AND (`at_special_from_date`.`store_id` = 6)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date_default` ON (`at_special_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date_default`.`attribute_id` = '63') AND `at_special_to_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '63') AND (`at_special_to_date`.`store_id` = 6)
LEFT JOIN `catalogrule_product_price` ON (catalogrule_product_price.product_id=e.entity_id) AND ((catalogrule_product_price.rule_date is null) or (catalogrule_product_price.rule_date='2021-01-06' and catalogrule_product_price.website_id='1' and catalogrule_product_price.customer_group_id='0'))
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=6 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
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 (at_special_price.value > 0) AND (IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) <= '2021-01-06 00:00:00') AND ((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2021-01-06 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS null)) ORDER BY IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) desc
Unsere Plot-
Dienstleistungen
Dienstleistungen
Sonderangebote
-
Neu
-
Regulärer Preis: 2.100,00 €
Special Price 1.899,00 €
HP DesignJet T630 - ...
91,4 cm GroßformatdruckerNeu -
Regulärer Preis: 615,00 €
Special Price 599,00 €
Neolt TRIM 200
Manuelle Schneidemaschine bis 200 cm -
Regulärer Preis: 2.300,00 €
Special Price 1.999,00 €
HP DesignJet T650 - ...
91,4 cm GroßformatdruckerNeu -
Regulärer Preis: 1.500,00 €
Special Price 1.349,00 €
HP DesignJet T650 - ...
61,0 cm GroßformatdruckerNeu -
Regulärer Preis: 1.350,00 €
Special Price 1.199,00 €
HP DesignJet T630 - ...
61,0 cm GroßformatdruckerNeu -
Regulärer Preis: 1.000,00 €
Special Price 899,00 €
HP DesignJet T250
61,0 cm (24") GroßformatdruckerNeu -
Regulärer Preis: 1.779,00 €
Special Price 1.699,00 €
Neolt Elektro TRIM 2...
Elektrische Schneidemaschine bis 200 cm -
209,00 € So niedrig wie: 134,00 €
HP Papierzuführung 5...
für PageWide Pro 452dn, 452dw, 477dn, 477dw -
Regulärer Preis: 6.720,00 €
Special Price 5.369,00 €
HP DesignJet T1600dr...
91,4 cm Plotter mit 2 Rollen -
Regulärer Preis: 4.935,00 €
Special Price 3.900,00 €
HP DesignJet T1600dr...
91,4 cm Plotter mit 2 Rollen -
Regulärer Preis: 3.675,00 €
Special Price 2.899,00 €
HP DesignJet T1600 -...
91,4 cm Plotter mit 1 Rolle -
Regulärer Preis: 9.600,00 €
Special Price 7.789,00 €
HP DesignJet T2600 -...
91,4 cm Plotter mit 1 Rolle -
Regulärer Preis: 12.100,00 €
Special Price 9.639,00 €
HP DesignJet T2600dr...
91,4 cm Plotter mit 2 Rollen -
Regulärer Preis: 5.460,00 €
Special Price 4.379,00 €
HP DesignJet T1600 -...
91,4 cm Plotter mit 1 Rolle -
Regulärer Preis: 15.900,00 €
Special Price 13.289,00 €
HP DesignJet Z6810 -...
152,4 cm Großformatdrucker -
Regulärer Preis: 9.599,00 €
Special Price 8.499,00 €
HP DesignJet Z6610 -...
152,4 cm Großformatdrucker -
Regulärer Preis: 8.999,00 €
Special Price 8.499,00 €
HP DesignJet Z6810 -...
106,7 cm Großformatdrucker -
Regulärer Preis: 6.399,00 €
Special Price 5.389,00 €
HP DesignJet T1700dr...
111,8 cm Großformatdrucker -
Regulärer Preis: 5.199,00 €
Special Price 4.389,00 €
HP DesignJet T1700 4...
111,8 cm Großformatdrucker -
Regulärer Preis: 6.830,00 €
Special Price 5.199,00 €
HP DesignJet Z6dr - ...
2 Rollen 111,8 cm PostScript Fotodrucker -
Regulärer Preis: 6.530,00 €
Special Price 4.899,00 €
HP DesignJet Z9+ - 4...
111,8 cm PostScript Fotodrucker -
Regulärer Preis: 5.630,00 €
Special Price 4.499,00 €
HP DesignJet Z6 - 44...
111,8 cm PostScript Fotodrucker -
Regulärer Preis: 3.400,00 €
Special Price 2.759,00 €
HP DesignJet Z9+ - 2...
61,0 cm PostScript FotodruckerNeu -
Regulärer Preis: 7.730,00 €
Special Price 6.159,00 €
HP DesignJet Z9+dr -...
2 Rollen 111,8 cm PostScript FotodruckerNeu -
Regulärer Preis: 4.799,00 €
Special Price 3.999,00 €
HP DesignJet T1700dr...
111,8 cm Großformatdrucker mit 2 Rollen -
Regulärer Preis: 3.599,00 €
Special Price 2.949,00 €
HP DesignJet T1700 4...
111,8 cm Großformatdrucker -
Regulärer Preis: 2.650,00 €
Special Price 1.949,00 €
HP DesignJet T830 MF...
61,0 cm Multifunktionsdrucker
Wir sind für Sie da
Neuigkeiten
x
Preis:
Tatsächlicher Preis:
Our price is lower than the manufacturer's "minimum advertised price." As a result, we cannot show you the price in catalog or the product page.
You have no obligation to purchase the product once you know the price. You can simply remove the item from your cart.
You have no obligation to purchase the product once you know the price. You can simply remove the item from your cart.
Our price is lower than the manufacturer's "minimum advertised price." As a result, we cannot show you the price in catalog or the product page.
You have no obligation to purchase the product once you know the price. You can simply remove the item from your cart.
You have no obligation to purchase the product once you know the price. You can simply remove the item from your cart.