JOUW AANKOOP

De reservering van de artikelen eindigt in
De reserveringstijd is helaas verlopen
Er ontbreekt nog voor gratis verzending.
MET DEZE AANKOOP BESPAAR JE
TOEVOEGEN

Je mandje is leeg

GA NAAR DE WINKEL
Subtotaal
Totale korting
-
Verzendkosten
Onder rembours
TOTAAL (Incl. BTW)
WIJZE VAN BETALEN
Mijn tegoed

Andere niet gespecificeerde wijze van betalen

%

-
Ik ben mijn wachtwoord vergeten

Ben je het wachtwoord vergeten?

MY FAVORITES

  • ZOEK OP:
  • Availables
  • Not availbles for now
  • Sold
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
Add to cartAdd to cartKledingstukAvailabilityRemove