Café & Mate

Filtrar por
Filtrar Por
Categoría
Tallas
Color
Más Filtros
SELECT DISTINCT  1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`price_view`, `e`.`url_key`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`weltpixel_hover_image`, `e`.`destacado2`, `e`.`discount_percent_filter`, `e`.`tela`, `e`.`tela_value`, `e`.`destacado5`, `e`.`destacado4`, `e`.`rt_only`, `e`.`sin_stock`, `e`.`destacado`, `e`.`child_color_sku`, `e`.`new_arrival`, `e`.`edit_choice`, `e`.`disponibilidad_tienda_fisica`, `e`.`tipo_fit`, `e`.`tipo_fit_value`, `e`.`color_multiple`, `e`.`material`, `e`.`sale`, `e`.`nombre_ingles`, `e`.`marca`, `e`.`marca_value`, `e`.`cyber`, `e`.`destacado3`, `e`.`oversized`, `e`.`genero`, `e`.`genero_value`, `e`.`disponible_online`, `e`.`color`, `e`.`color_value`, `e`.`priority_order`, `e`.`udropship_vendor`, `e`.`udropship_vendor_value`, `e`.`retiro_express`, `e`.`retiro_express_value`, `e`.`mp_sizechart`, `e`.`curva`, `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`, `price_index`.`udmp_new_min_price`, `price_index`.`udmp_new_max_price`, `price_index`.`udmp_new_cnt`, `price_index`.`udmp_used_min_price`, `price_index`.`udmp_used_max_price`, `price_index`.`udmp_used_cnt`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `product_entity`.`row_id`, `stock_status_index`.`is_salable` FROM `catalog_product_flat_2` AS `e`
 INNER JOIN `udropship_vendor_product_limit` AS `udsclimit` ON e.entity_id=udsclimit.product_id
 INNER JOIN `catalog_product_index_price_ws2` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0 and price_index.udropship_vendor=0
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in <= '1670199120' AND product_entity.updated_in > '1670199120')
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in <= '1670199120' AND product.updated_in > '1670199120')
 INNER JOIN `inventory_stock_4` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (udsclimit.class_id in (-1, '*')) AND (stock_status_index.is_salable = 1) AND (e.entity_id IN (1374596, 1372330, 1372331, 1344373, 1344375, 1368952, 1368950, 1368948, 1368964, 1368962, 1374597, 1372328, 1372327, 1371195, 1350403, 522703, 563582, 563583, 1350400, 1359111, 1350399, 1350386, 1350385, 1350383, 1350382, 1350381, 1350394, 1350393, 1350392, 1350391)) ORDER BY FIELD(e.entity_id,1374596,1372330,1372331,1344373,1344375,1368952,1368950,1368948,1368964,1368962,1374597,1372328,1372327,1371195,1350403,522703,563582,563583,1350400,1359111,1350399,1350386,1350385,1350383,1350382,1350381,1350394,1350393,1350392,1350391)
Ver como Parrilla Lista

30 artículos

Por página
  1. SET 2 TAZAS ESMALTADAS
    33% off
    SET 2 TAZAS ESMALTADAS
    Precio habitual $29.990 | Precio especial $19.990
  2. TAZA ACERO INOXIDABLE
    31% off
    TAZA ACERO INOXIDABLE
    Precio habitual $12.990 | Precio especial $8.990
  3. VASO ACERO INOXIDABLE
    30% off
    VASO ACERO INOXIDABLE
    Precio habitual $9.990 | Precio especial $6.990
  4. Matera Verde 350ml
    55% off
    Matera Verde 350ml
    Precio habitual $21.990 | Precio especial $9.990
  5. Matera Gris Oscuro 350ml
    55% off
    Matera Gris Oscuro 350ml
    Precio habitual $21.990 | Precio especial $9.990
  6. DELTA INSUL-MUG
    30% off
    DELTA INSUL-MUG
    $16.900
  7. DELTA INSUL-MUG
    30% off
    DELTA INSUL-MUG
    $16.900
  8. DELTA INSUL-MUG
    30% off
    DELTA INSUL-MUG
    $16.900
  9. MUG 360 Degrees Large 474 Ml.
    30% off
    MUG 360 Degrees Large 474 Ml.
    Precio habitual $14.900 | Precio especial $10.430
  10. MUG 360 Degrees Large 474 Ml.
    MUG 360 Degrees Large 474 Ml.
    $14.900
  11. TAZA DISEÑO CONDOR
    TAZA DISEÑO CONDOR
    $9.990
  12. TAZA DISEÑO PAISAJE
    TAZA DISEÑO PAISAJE
    $9.990
  13. TAZA DISEÑO PIES
    TAZA DISEÑO PIES
    $9.990
  14. X-Brew Coffee Dripper
    X-Brew Coffee Dripper
    $14.900
  15. CAFETERA FRENCH PRESS CLASSIC | 1.4 LT.
    CAFETERA FRENCH PRESS CLASSIC | 1.4 LT.
    $83.990
    Envío Gratis
  16. COFFEE PRESS
    COFFEE PRESS
    $12.900
  17. MATE STANLEY NEGRO 236 ML
    MATE STANLEY NEGRO 236 ML
    $22.990
  18. MATE STANLEY VERDE 236 ML
    MATE STANLEY VERDE 236 ML
    $22.990
  19. Mug French Press Classic | 473 ml
    Mug French Press Classic | 473 ml
    $39.990
  20. Prensa para café - Grande Coffee Press-Silicone
    Prensa para café - Grande Coffee Press-Silicone
    $23.990
  21. Set De Cocina Sts X-Set 3 Pce'S
    Set De Cocina Sts X-Set 3 Pce'S
    $54.900
    Envío Gratis
  22. Vaso X-Cup
    Vaso X-Cup
    $10.900
  23. Vaso X-Cup
    Vaso X-Cup
    $10.900
  24. Vaso X-Cup
    Vaso X-Cup
    $10.900
  25. Vaso X-Cup
    Vaso X-Cup
    $10.900
  26. Vaso X-Cup
    Vaso X-Cup
    $10.900
  27. X-MUG
    X-MUG
    $13.900
  28. X-MUG
    X-MUG
    $13.900
  29. X-MUG
    X-MUG
    $13.900
  30. X-MUG
    X-MUG
    $13.900
Ver como Parrilla Lista

30 artículos

Por página