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

Ingresa tu
Vehículo
0
Carro 0
$0

CAJA DE TRANSFERENCIA

Compatible con:
    Compatible con:

29

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 (165051, 156504, 239948, 238082, 238081, 238080, 238079, 238078, 238077, 238076, 238075, 238074, 238073, 238072, 238071, 238070, 238069, 238068, 238067, 238066, 238065, 238064, 238063, 238062, 238061, 238060, 227338, 106905, 169410))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,165051,156504,239948,238082,238081,238080,238079,238078,238077,238076,238075,238074,238073,238072,238071,238070,238069,238068,238067,238066,238065,238064,238063,238062,238061,238060,227338,106905,169410)

29 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. RETEN CAJA TRANSFERENCIA - SUZUKI. Compatibilidades: SUZUKI GRAND NOMADE 2.5 H25A/SQ625 (1998-2006), SUZUKI GRAND NOMADE 2.0 J20A/SQ420 (1998-2005), SUZUKI VITARA 1.6 G16A 8V (1989-1997), SUZUKI GRAND VITARA 1.6 G16B/SQ416 (1998-2006), SUZUKI VITARA SIDEKICK G16 (1992-1997), SUZUKI GRAND NOMADE 2.0 RF 8V (2000-2001), SUZUKI VITARA 1.6 G16B 16V (1993-1998), SUZUKI GRAND VITARA 2.0 J20A/SQ420 (1998-2005), SUZUKI VITARA 1.9 XUD9AL (1999), SUZUKI GRAND NOMADE 2.0 H20A/SV620 V6 (1995-1999), SUZUKI GRAND NOMADE 2.0 RHZ 8V (2001-2003) Saber más
  2. RETEN CAJA TRANSFERENCIA - MITSUBISHI. Compatibilidades: MITSUBISHI MONTERO SPORT G2 2.5 4D56K (2008), MITSUBISHI L200 2.5 4D56T/KB4T (2007-2015), MITSUBISHI L200 2.5 4D56T/KA4T (2007-2015), MITSUBISHI MONTERO SPORT 3.0 6G72/K96W (1997-2002), MITSUBISHI MONTERO SPORT 3.0 6G72Q/K96 (2003-2008), MITSUBISHI MONTERO 3.2 4M41T/V78W (2000-2007), MITSUBISHI MONTERO 3.2 4M41T/V98W (2008-2014), MITSUBISHI MONTERO 3.5 6G74/V75W (2001-2005), MITSUBISHI MONTERO 3.8 DOHC 6G75/V67W (2004-2006), MITSUBISHI MONTERO 3.5 6G74/V45W (1997-2001), MITSUBISHI MONTERO 3.8 6G75/V97W (2007-2010), MITSUBISHI MONTERO SPORT 3.5 6G74/K99W (2002-2005) Saber más

29 productos

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