030-588 49 102

Zusammenfassung

Deine Artikel sind nur kurze Zeit reserviert
Beeilung, deine Artikel sind nicht mehr für dich reserviert
Es fehlen für Gratis-Versandkosten (gültig bis Ende Juni)
Mit diesem Kauf sparst du
In den Warenkorb

Dein Warenkorb ist noch leer

ZUM SHOP
Gesamtsumme
Total Rabatt
-
Versandkosten
Gebühr für Zahlungsart
Gesamtsumme (inkl. MwSt.)
Zahlungsmethode
Mein Guthaben

Anderes Zahlungsmittel

%

-
Passwort vergessen?

Passwort vergessen?

MAINE FAVORITEN

  • Filtern nach:
  • Verfügbar
  • Noch nicht verfügbar
  • Verkauft
SELECT SQL_CALC_FOUND_ROWS f.id_product, f.id_customer, f.favorite_type, pp.soldOn, IF(cp.id_product IS NULL, false, true) as in_other_cart, IF(pod.quantity_customer_return = 1, true, false) as asked_return, IF( ppl.name IS NULL, IF(fvl.value IS NULL, 'No translation', fvl.value), ppl.name ) as name, ppl.link_rewrite, pim.real_uri as productRealUris, i.id_image, i.id_image_kirondo, i.file_kirondo, pim.serverPath, pim.real_uri, m.name as manufacturer, ROUND(cfp.store_price,2) as pvp, IF(p.active IN (0, 1), true, false) as `stored`, pp.id_target FROM favorites f INNER JOIN PercentilProduct pp on pp.id_product = f.id_product INNER JOIN ps_product p ON p.id_product = f.id_product INNER JOIN ps_manufacturer m ON m.id_manufacturer = p.id_manufacturer INNER JOIN customer_extra_info cei ON cei.id_customer = f.id_customer INNER JOIN Websites w ON w.id_website = cei.id_site LEFT JOIN cache_filter_product cfp ON cfp.id_product = f.id_product AND cfp.id_site = cei.id_site LEFT JOIN ps_image i ON i.id_product = f.id_product AND i.cover = 1 LEFT JOIN PercentilImage pim ON pim.id_image = i.id_image LEFT JOIN ps_product_lang ppl ON f.id_product = ppl.id_product AND w.id_lang = ppl.id_lang LEFT JOIN ps_cart_product cp ON cp.id_product = f.id_product AND fin_reserva > NOW() LEFT JOIN ps_order_detail pod ON pod.product_id = f.id_product AND pod.product_quantity_return = 0 LEFT JOIN ps_feature_product fp ON fp.id_product = f.id_product AND fp.id_feature in (49,43,543) LEFT JOIN ps_feature_value_lang fvl ON fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = w.id_lang WHERE true AND f.id_customer IN () GROUP BY f.id_product
In den warenkorb legenHinzufügenKategorieVerfügbarkeitLöschen