Estamos en Cyber con miles de descuentos y la campaña solidaria #LitroxLitro

Ingresa tu
Vehículo
0
Carro 0
$0

EMPAQUETADURA BOMBA DE ACEITE

Compatible con:
    Compatible con:

8

SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `at_qty`.`qty`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_item` AS `at_qty` ON (at_qty.`product_id`=e.entity_id) AND (at_qty.stock_id=1) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((at_qty.qty > 0) AND (stock_status_index.stock_status = 1) AND (e.entity_id IN (145821, 145820, 227443, 227442, 227441, 227440, 227439, 227438))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,145821,145820,227443,227442,227441,227440,227439,227438)

8 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. EMPAQ BOMBA AGUA - KIA MOTORS / HYUNDAI. Compatibilidades: HYUNDAI TRAJET 2.0 G4GC CVVT (2004-2010), HYUNDAI ELANTRA 1.8 G4GB DOHC (2001-2007), HYUNDAI TUCSON 2.0 G4GC BENCINA (2004-2010), HYUNDAI MATRIX 1.8 G4GB (2001-2005), HYUNDAI ELANTRA 2.0 G4GF DOHC (2001-2004), HYUNDAI ELANTRA 1.8 G4GM DOHC (1996-1999), HYUNDAI ELANTRA 1.6 G4GR- DOHC (1996-2000), HYUNDAI COUPE FX 2.0- G4GF DOHC (1996-2001), HYUNDAI TIBURON 1.8 G4GM DOHC (1996-2000), HYUNDAI AVANTE 1.8 G4GM DOHC BETA (1996-2001), HYUNDAI AVANTE 1.5 G4FK DOHC (1995-2000), HYUNDAI SONATA 2.0 L4GC EF DOHC (1999-2004), KIA MOTORS SPORTAGE PRO 2.0 G4GC (2005-2009), KIA MOTORS CARENS 2.0 DOHC G4GC (2005-2007) Saber más
  2. EMPAQ BOMBA AGUA - KIA MOTORS / HYUNDAI. Compatibilidades: HYUNDAI ACCENT 1.6 G4ED DOHC CVVVT (2006-2011), HYUNDAI ACCENT 1.4 G4EE DOHC (2006-2011), HYUNDAI ACCENT 1.5 G4AK DOHC (1996-1999), HYUNDAI ACCENT PRIME 16 G4ED DOHC (2003-2006), HYUNDAI ELANTRA 1.6 G4ED DOHC (2001-2007), HYUNDAI MATRIX 1.6 G4ED DOHC (2001-2007), HYUNDAI GETZ 1.4 G4AE DOHC (2006-2009), HYUNDAI GETZ 1.6 G4ED DOHC (2002-2005), HYUNDAI ACCENT PRIME 1.5 G4EC DOHC (2000-2006), KIA MOTORS CERATO 1.6 G4ED (2004-2007), KIA MOTORS RIO(II) 1.4 JB G4EE (2006-2011) Saber más

8 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página