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

Ingresa tu
Vehículo
0
Carro 0
$0

Herramientas

Herramientas

28

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 (165115, 164494, 164414, 164263, 164262, 164261, 163774, 163716, 163627, 142307, 8518, 224343, 224306, 224305, 224259, 224258, 224257, 171632, 171629, 171622, 171620, 171617, 142308, 233222, 226875, 171627, 171616, 169381))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,165115,164494,164414,164263,164262,164261,163774,163716,163627,142307,8518,224343,224306,224305,224259,224258,224257,171632,171629,171622,171620,171617,142308,233222,226875,171627,171616,169381)

28 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. DESTORNILLADOR PC 3 X 125MM - VOLKSWAGEN / TOYOTA / SUZUKI / NISSAN / KIA MOTORS / DAIHATSU / CHANGAN / ASIA. Compatibilidades: KIA MOTORS FRONTIER 2.7 J2 (1998-2003), KIA MOTORS K3500 SL K3500 SL (1991-1995), KIA MOTORS RIO(I) 1.5 DOHC A5D (2000-2002), KIA MOTORS RIO(I) 1.3 SOHC A3E (1999-2002), KIA MOTORS BESTA PREGIO 2.7 J2 (1998-2003), KIA MOTORS BESTA ULTRA 2.7 J2 (2004-2006), KIA MOTORS BESTA 2.2 R2 (1990-1997), KIA MOTORS PRIDE 1.3 B3 (1993-2001), KIA MOTORS PRIDE POP 1.1 B1 (1993-2001), KIA MOTORS K2400 SF K2400 SF (1990-1997), KIA MOTORS AVELLA(II) 1.3 SOHC B3 (1998-2001), KIA MOTORS AVELLA(I) 1.5 DOHC B5 (1996-1998), KIA MOTORS AVELLA(II) 1.5 SOHC B5 (1998-2001), KIA MOTORS RIO(II) 1.3 A3E (2003-2006), KIA MOTORS CARENS 1.8 DOHC TB (2001-2005), KIA MOTORS CARENS 2.0 SOHC D4EA (2003-2006), KIA MOTORS RIO(II) 1.5 A5D (2003-2006), TOYOTA NEW YARIS 1.3 2NZFE NCP90 SPORT (2006-2011), TOYOTA NEW YARIS 1.5 1NZFE NCP93 SEDAN (2006-2013), TOYOTA DYNA 3.0 B BU 83 (1988-1995), TOYOTA YARIS 1.5 1NZFE NCP12 (1999-2005), TOYOTA STARLET 1.2 3K (1979-1982), TOYOTA HILUX 2.2 L LN30/40/50/55 (1981-1988), TOYOTA HILUX 2.4 2RZ 2WD RZN148 (1998-2005), TOYOTA COROLLA 1.3 EE90-2E (1988-1992), TOYOTA TERCEL 1.32EEL40 (1990-1992), TOYOTA HILUX 2.4 22R 4WD (1994-1997), TOYOTA CORONA 1.8 3T (1981-1983), TOYOTA COROLLA 1.6 2T (1979-1983), TOYOTA HILUX 1.8 2Y YN85 (1989-1994), TOYOTA HILUX 2.4 22R 2WD (1994-1997), TOYOTA TERCEL 1.5 3E EL42 U.S.A (1993-1994), TOYOTA HIACE 1.6 12R (1977-1983), TOYOTA TERCEL 1.5 5EFE TWIN-CAM (1995-1999), TOYOTA HIACE 1.8 2Y YH50/60 (1983-1986), TOYOTA STARLET 1.3 4EFE EP91 (1995-1999), TOYOTA HILUX 1.6 1Y YN50/55 (1984-1988), TOYOTA CELICA 1.6 2T (1978-1981), TOYOTA DYNA 3.0 B (1978-1984), TOYOTA COROLLA 1.3 4K KE70E (1980-1983), TOYOTA COROLLA 1.2 3K (1974-1979), TOYOTA HIACE 2.0 3Y YH51/61 (1987-1989), TOYOTA COROLLA 1.6 4AFE- AE101 (1993-1997), TOYOTA CORONA 2.0 STW (1977-1980), TOYOTA TACOMA 4.0 1GRFE DOHC (2008-2013), SUZUKI SWIFT 1.3 G13 SOHC 5PTAS (1989-1996), SUZUKI SWIFT 1.3 G13 SOHC 4PTAS (1989-1996), SUZUKI MARUTI 0.8 F8B/MA800 (1999-2008), SUZUKI MARUTI 0.8 F8B/FB308 (1995-1999), SUZUKI FRONTE 0.8 SS80/F8B (1981-1983), SUZUKI SAMURAI 1.3 G13A/SJ413 (1984-1996), SUZUKI VITARA 1.6 G16A 8V (1989-1997), SUZUKI FURGON ST90/F8A (1980-1985), SUZUKI CARRY PICK UP 1.0 F10A/SK410 (1988-1998), SUZUKI CARRY VAN 1.0 F10A/SK410 (1988-1998), SUZUKI FURGON 0.8 ST80/F8A (1978-1979), SUZUKI FRONTE 550 F5A/SS40 (1979-1980), SUZUKI SWIFT 1.0 G10 SOHC (1985-1989), SUZUKI FORZA 1.3 G13/SA413 (1985-1987), SUZUKI FORZA 1.0 G10/SA310 (1985-1988), SUZUKI FRONTE 0.8 SB308/F8A (1986-1988), SUZUKI JEEP 1.0 SJ410/F10A (1982-1985), SUZUKI CERVO 1.0 SC100/F10A (1981-1985), SUZUKI CERVO 0.8 SC80/F8A (1979-1980), NISSAN TERRANO 3.0 ZD30 4WD (2003-2006), NISSAN TERRANO 3.2 QD32 4WD (1998-2003), NISSAN D21 2.4 D21 EGI 4WD (1993-1997), NISSAN 180B 1.8 L18 (1977-1980), NISSAN 160J 1.6 L16 (1973-1981), NISSAN SENTRA 1.8 QG18DE/B15 (2000-2007), NISSAN TERRANO 2.5 YD25/DTI 2WD (2003-2010), NISSAN X-TRAIL 2.2 YD22ETI/T30 (2002-2007), NISSAN V16 1.6 E16 T/ROJA (1993-1996), NISSAN V16 1.6 GA16DNE T/PLOMA (1998-2010), NISSAN V16 1.6 GA16 T/PLOMA (1993-1997), NISSAN D21 2.4 D21 EGI 2WD (1993-2002), NISSAN V16 1.4 GA14DS C/CADENA (1990-1992), NISSAN SENTRA 1.6 E16 (1988-1992), NISSAN BLUE BIRD 1.8 L18 (1980-1983), NISSAN D21 2.4 D21/Z24 (1989-1993), NISSAN D21 2.0 D21/Z20 (1989-1992), NISSAN SUNNY 1.5 E15 (1982-1992), NISSAN TERRANO 2.5 YD25DTI/D22X 2WD (2010), NISSAN 150Y 1.5 A15 (1981-1982), NISSAN 160B 1.6 L16 (1973-1979), NISSAN 240L 2.4 L2 (1980-1983), NISSAN 140Y 1.4 A14 (1978-1980), NISSAN SUNNY 1.3 E13 (1982-1993), NISSAN 120Y 1.2 A12 (1973-1982), NISSAN MARCH 1000 K10 (1982-1992), NISSAN BLUE BIRD 1.8 SR18DE/U13 (1991-1995), ASIA TOPIC FURGON 2.7 (1991-2000), CHANGAN S-300 FURGON 1.0 SOHC (2008), CHANGAN S-200 PICK-UP 1.0 SOHC C/DOBLE (2008), CHANGAN S-100 PICK-UP 1.0 SOHC C/SIMPLE (2008-EN ADELANTE), DAIHATSU CHARADE G20 CD 850 (1978-1984), DAIHATSU CUORE 550 L55AB (1981-1984), DAIHATSU MAX CUORE 550 L40AB (1978-1980), DAIHATSU FURGON 550 S60AB (1978-1982), DAIHATSU GIRO 1.0 (1988-1993), DAIHATSU CHARADE G21 CB 850 (1985-1987), DAIHATSU FURGON HIJET 1.0 S85 (1987-1992), DAIHATSU TERIOS 1.3K3VE DOHC (2001-2006), DAIHATSU CHARMANT 1.62TA40 (1979-1982), DAIHATSU FURGON 850 S70CB (1984-1986), DAIHATSU TERIOS 1.3 HC-EJSOHC (1997-2000), DAIHATSU APPLAUSE 1.6 HD SOHC (1989-1998), DAIHATSU CUORE 850 L80ED-20 (1994-1998), DAIHATSU JEEP ROCKY 2.0 3Y (1984-1993), DAIHATSU JEEP F20 1.612R (1976-1980), VOLKSWAGEN AMAROK 2.0 (2015) Saber más

28 productos

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