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

Ingresa tu
Vehículo
0
Carro 0
$0

SENSOR DE PRESIóN ADMISIóN

Compatible con:
    Compatible con:

43

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 (165090, 168389, 168387, 168388, 239925, 239924, 239813, 239812, 239811, 239644, 239595, 239594, 239583, 239580, 239576, 239574, 239565, 239533, 239517, 239516, 239515, 239512, 107847, 107687, 107604, 107603, 107602, 107601, 107600, 107599, 107591, 107588, 107586, 107585, 107584, 107581, 107580, 107579, 107577, 107576, 107575, 107572, 107570))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,165090,168389,168387,168388,239925,239924,239813,239812,239811,239644,239595,239594,239583,239580,239576,239574,239565,239533,239517,239516,239515,239512,107847,107687,107604,107603,107602,107601,107600,107599,107591,107588,107586,107585,107584,107581,107580,107579,107577,107576,107575,107572,107570)

43 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. Vehículos compatibles
    • HYUNDAI > ACCENT
    • HYUNDAI > AZERA
    • HYUNDAI > COUNTY
    • HYUNDAI > CRETA
    • HYUNDAI > ELANTRA
    • HYUNDAI > GENESIS
    • HYUNDAI > GETZ
    • HYUNDAI > H1
    • HYUNDAI > I30
    • HYUNDAI > I40
    • HYUNDAI > MATRIX
    • HYUNDAI > SANTA FE
    • HYUNDAI > SONATA
    • HYUNDAI > VELOSTER
    • HYUNDAI > VENUE
    • HYUNDAI > VERACRUZ
    • KIA MOTORS > CARENS
    • KIA MOTORS > CEED
    • KIA MOTORS > CERATO
    • KIA MOTORS > MOHAVE
    • KIA MOTORS > MORNING
    • KIA MOTORS > OPTIMA
    • KIA MOTORS > SORENTO
    • KIA MOTORS > SOUL
    • KIA MOTORS > SPORTAGE
    • KIA MOTORS > STINGER
    Ver más
    SENSOR MAP ORIGINAL Accent 2005 - 2021 Saber más
  2. SENSOR - OPEL / DAEWOO / CHEVROLET. Compatibilidades: OPEL CORSA 1.6 C16NZ (1996-2009), OPEL CORSA 1.4 C14NZ (1995-1999), OPEL COMBO 1.6 C16NZ SOHC, OPEL CORSA 1.0 X10XE SOHC (1997-1998), OPEL ASTRA 1.4 SOHC C14NZ (1992-1998), OPEL VECTRA 2.0 SOHC (1992-1996), OPEL VECTRA 1.6 SOHC (1991-1995), OPEL COMBO 1.4 SOHC C14NZ (1995-1999), OPEL VECTRA 1.8 SOHC (1991-1995), OPEL ASTRA 1.6 DOHC C16XE ALEMAN, OPEL VECTRA 1.6 X16XEL DOHC, CHEVROLET CORSA EXTRA 1.6 C16NZ (1998-2007), CHEVROLET MONZA 2.0 (1987-1997), CHEVROLET MONZA 1.8 (1987-1996), DAEWOO HEVEN 1500 G15MF-SOHC, DAEWOO RACER 1500 M68, DAEWOO RACER 1500 G15MF-SOHC, DAEWOO RACER 1500 M08, DAEWOO RACER 1500 M19 Saber más
  3. SENSOR - KIA MOTORS / HYUNDAI. Compatibilidades: HYUNDAI TUCSON 2.0 G4KD DOHC CVVT (2010-2014), HYUNDAI ACCENT RB 1.4 G4FA MPI DOHC (2011-2014), HYUNDAI ACCENT RB 1.6 G4FC MPI 16-VAL (2012-2019), HYUNDAI ELANTRA 1.6 G4FG DOHC MPI (2011-2016), HYUNDAI SANTA FE 2.4 G4KE DOHC (2010), HYUNDAI I10 1.2 G4LA DOHC MPI (2012-2018), HYUNDAI SANTA FE 2.4 G4KE (2018), HYUNDAI SONATA NF 2.0 G4KD DOHC (2009-2010), HYUNDAI I30 1.6 G4FC GAMMA DOHC 16V CVVT (2007-2014), HYUNDAI SONATA NEW 2.0 G4KD DOHC (2010-2013), HYUNDAI VELOSTER 1.6 G4FG DOHC MPI (2011-2017), HYUNDAI SONATA YF 2.4 G4KE DOHC MPI (2011-2014), HYUNDAI I30 1.6 G4FG (2018), HYUNDAI I30 2.0 G4NA (2018), KIA MOTORS CERATO 5 1.6 G4FC HATCHBACK (2011-2013), KIA MOTORS KOUP 1.6 G4FC GAMMA MPI DOHC (2010-2013), KIA MOTORS SORENTO 2.4 G4KE (2010-2015), KIA MOTORS RIO 4 SEDAN 1.4 G4FA MPI DOHC 16V (2012-2018), KIA MOTORS RIO 5 1.4 G4FA GAMMA UB MPI CVVT 16V (2012-2018), KIA MOTORS RIO 4 SEDAN 1.2 G4LA (2012), KIA MOTORS SORENTO 2.4 G4KE DOHC (2017), KIA MOTORS RIO 3 1.4 G4FA GAMMA MPI 16V HBACK (2012-2018), KIA MOTORS SOUL 1.6 G4FC (2008-2011), KIA MOTORS CERATO 1.6 GAMMA G4FC MPI DOHC 16V (2010-2014), KIA MOTORS CERATO 1.6 DOHC G4FC CVVT (2007-2009), KIA MOTORS SOUL 1.6 G4FG (2014), KIA MOTORS OPTIMA 2.4 G4KE (2011) Saber más
  4. SENSOR - KIA MOTORS / HYUNDAI. Compatibilidades: HYUNDAI ACCENT 1.6 G4ED DOHC CVVVT (2006-2011), HYUNDAI ACCENT 1.4 G4EE DOHC (2006-2011), HYUNDAI ACCENT PRIME 16 G4ED DOHC (2003-2006), HYUNDAI ACCENT 1.3 G4EA SOHC (2004-2006), HYUNDAI TRAJET 2.0 G4GC CVVT (2004-2010), HYUNDAI ATOS 1.0 G4HC GL OHC (1999-2004), HYUNDAI ATOS 800 G4HA OHC (1998-2000), HYUNDAI ELANTRA 1.8 G4GB DOHC (2001-2007), HYUNDAI ELANTRA 1.6 G4ED DOHC (2001-2007), HYUNDAI SANTA FE 2.4 G4JS BENCINA (2000-2005), HYUNDAI MATRIX 1.6 G4ED DOHC (2001-2007), HYUNDAI TUCSON 2.0 G4GC BENCINA (2004-2010), HYUNDAI ACCENT PRIME 1.5 G4EB SOHC (2000-2006), HYUNDAI SONATA 2.0 G4JP EF SIRIUS (1999-2001), HYUNDAI I10 1.1 G4HG EPSILON MPI SOHC 12V (2008-2014), HYUNDAI MATRIX 1.8 G4GB (2001-2005), HYUNDAI I30 1.6 G4FG DOHC 16-V CVVT (2012-2015), HYUNDAI ELANTRA 2.0 G4GC DOHC (2007-2011), HYUNDAI ACCENT PRIME 1.5 G4EC DOHC (2000-2006), HYUNDAI I30 1.6 G4FC GAMMA DOHC 16V CVVT (2007-2014), HYUNDAI VELOSTER 1.6 G4FG DOHC MPI (2011-2017), HYUNDAI ATOS PRIME 1.0 G4HC (1999-2004), HYUNDAI SONATA 2.0 L4GC EF DOHC (1999-2004), KIA MOTORS MORNING 1.1 G4HG SOHC, KIA MOTORS CERATO 1.6 G4ED (2004-2007), KIA MOTORS SPORTAGE PRO 2.0 G4GC (2005-2009), KIA MOTORS RIO(I) 1.6 G4ED (2006-2007), KIA MOTORS OPIRUS 3.5 G6CU (2004-2007), KIA MOTORS CERATO 2.0 G4GC (2005-2007) Saber más
  5. SENSOR - KIA MOTORS / HYUNDAI. Compatibilidades: HYUNDAI ACCENT 1.6 G4ED DOHC CVVVT (2006-2011), HYUNDAI ACCENT 1.4 G4EE DOHC (2006-2011), HYUNDAI ACCENT 1.3 G4EH SOHC (1996-1999), HYUNDAI ACCENT PRIME 16 G4ED DOHC (2003-2006), HYUNDAI TRAJET 2.0 G4GC CVVT (2004-2010), HYUNDAI ATOS 1.0 G4HC GL OHC (1999-2004), HYUNDAI ATOS 800 G4HA OHC (1998-2000), HYUNDAI ELANTRA 1.8 G4GB DOHC (2001-2007), HYUNDAI ELANTRA 1.6 G4ED DOHC (2001-2007), HYUNDAI SANTA FE 2.4 G4JS BENCINA (2000-2005), HYUNDAI MATRIX 1.6 G4ED DOHC (2001-2007), HYUNDAI TUCSON 2.0 G4GC BENCINA (2004-2010), HYUNDAI GETZ 1.5 D4FA DOHC TCI (2006-2011), HYUNDAI ACCENT PRIME 1.5 G4EB SOHC (2000-2006), HYUNDAI SONATA 2.0 G4JP EF SIRIUS (1999-2001), HYUNDAI I10 1.1 G4HG EPSILON MPI SOHC 12V (2008-2014), HYUNDAI I30 1.6 G4FG DOHC 16-V CVVT (2012-2015), HYUNDAI ELANTRA 2.0 G4GC DOHC (2007-2011), HYUNDAI ACCENT PRIME 1.5 G4EC DOHC (2000-2006), HYUNDAI I30 1.6 G4FC GAMMA DOHC 16V CVVT (2007-2014), HYUNDAI VELOSTER 1.6 G4FG DOHC MPI (2011-2017), HYUNDAI ATOS PRIME 1.0 G4HC (1999-2004), HYUNDAI SONATA 2.0 L4GC EF DOHC (1999-2004), KIA MOTORS MORNING 1.1 G4HG SOHC, KIA MOTORS CERATO 1.6 G4ED (2004-2007), KIA MOTORS SPORTAGE PRO 2.0 G4GC (2005-2009), KIA MOTORS RIO(I) 1.6 G4ED (2006-2007), KIA MOTORS RIO(II) 1.4 JB G4EE (2006-2011), KIA MOTORS OPIRUS 3.5 G6CU (2004-2007), KIA MOTORS CERATO 2.0 G4GC (2005-2007) Saber más
  6. SENSOR M.A.P - CHEVROLET. Compatibilidades: CHEVROLET TRACKER 1.800 F18D DOHC 16 VAL, CHEVROLET SONIC SEDAN 1.6 A16XER F16D4 16V (2012), CHEVROLET SONIC HATCH 1.6 A16X F16D4 16V (2012), CHEVROLET AVEO II 1.4 -F14FD DOHC (2007-2016), CHEVROLET CAPTIVA 2.4 A24XE LD9 DOHC, CHEVROLET SPARK GT 1.2 B12D1 LMU, CHEVROLET AVEO H/BACK 1.4 DOHC (F14D3/L95) (2004-2016), CHEVROLET AVEO SEDAN 1.4 DOHC (F14D3/L14) (2004-2007), CHEVROLET SAIL 1.4 F14 LCU (2011-2017), CHEVROLET ORLANDO 2.4 LE5 Saber más
  7. SENSOR - OPEL / CHEVROLET. Compatibilidades: OPEL CORSA 1.6 C16NZ (1996-2009), OPEL CORSA 1.4 C14NZ (1995-1999), OPEL COMBO 1.6 C16NZ SOHC, OPEL CORSA 1.0 X10XE SOHC (1997-1998), OPEL ASTRA 1.4 SOHC C14NZ (1992-1998), OPEL VECTRA 2.0 SOHC (1992-1996), OPEL VECTRA 1.6 SOHC (1991-1995), OPEL COMBO 1.4 SOHC C14NZ (1995-1999), OPEL VECTRA 1.8 SOHC (1991-1995), OPEL ASTRA 1.6 DOHC C16XE ALEMAN, OPEL VECTRA 1.6 X16XEL DOHC, CHEVROLET CORSA EXTRA 1.6 C16NZ (1998-2007), CHEVROLET MONZA 2.0 (1987-1997), CHEVROLET MONZA 1.8 (1987-1996), DAEWOO HEVEN 1500 G15MF-SOHC, DAEWOO RACER 1500 M68, DAEWOO RACER 1500 G15MF-SOHC, DAEWOO RACER 1500 M08, DAEWOO RACER 1500 M19 Saber más

43 productos

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