¿Alguna pregunta?

TU COMPRA

La reserva de tus prendas finalizara en
Atencion estas prendas ya no estan reservadas
Te faltan para envío gratis.
CON ESTA COMPRA AHORRAS
AÑADIR

Este carrito se siente vacío

IR A LA TIENDA
Subtotal
Total descuentos
-
Gastos de envío:
Recargo contra reembolso
TOTAL PEDIDO (IVA Incl.)
MEDIO DE PAGO
Mi monedero

Otro medio de pago no especificado

%dto

-
Olvidé mi contraseña

¿Has olvidado tu contraseña?

MIS FAVORITOS

  • FILTRAR POR:
  • Disponibles
  • Aún no disponibles
  • Vendido
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
Añadir al carritoAñadirPrendaDisponibilidadEliminar