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

Ingresa tu
Vehículo
0
Carro 0
$0

MACHóN

Compatible con:
    Compatible con:

6

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 (233228, 233227, 233226, 233225, 233224, 233223))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,233228,233227,233226,233225,233224,233223)

6 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. MACHON CARDAN - UNIVERSAL / SUZUKI / MITSUBISHI / HYUNDAI / CHEVROLET. Compatibilidades: MITSUBISHI L200 2.5 4D56 2WD/K14T (1987-1998), MITSUBISHI L300 1.6 4G32 (1979-1986), MITSUBISHI L200 1.6 4G32/LO21P (1980-1986), MITSUBISHI GALANT 1.6 4G32/E31A (1977-1983), MITSUBISHI L200 2.5 4D56T4WD/K74T (1998-2006), MITSUBISHI DELICA 2.5 4D56/P25W (1992-1996), MITSUBISHI L200 2.0 4G63B 4WD/K32T (1987-1993), MITSUBISHI L200 1.6 4G32B 2WD/K11T (1987-1993), MITSUBISHI L300 1.4 4G33/36 (1977-1986), MITSUBISHI L200 2.4 4G64 4WD/K35T (1994-1998), MITSUBISHI DELICA 2.8 4M40 (1994-1998), MITSUBISHI L200 2.4 4G64 4WD/K75T (1998-2007), MITSUBISHI L300 1.6 4G32B (1987-1993), HYUNDAI PONY 1.2 4G36 (1977-1987), CHEVROLET N-300 MAX 1.2 LMU, SUZUKI GRAND NOMADE 2.0 J20A/JB420 (2006-2010), SUZUKI GRAND NOMADE 2.0 J20A/JB420W-5 (2012-2015), SUZUKI GRAND NOMADE/XL7 2.7 H27A (2001-2008), SUZUKI GRAND NOMADE 2.0 J20A/SQ420 (1998-2005), SUZUKI SAMURAI 1.3 G13A/SJ413 (1984-1996), SUZUKI VITARA 1.6 G16A 8V (1989-1997), SUZUKI GRAND VITARA 1.6 G16B/SQ416 (1998-2006), SUZUKI VITARA SIDEKICK G16 (1992-1997), SUZUKI CARRY PICK UP 1.0 F10A/SK410 (1988-1998), SUZUKI CARRY VAN 1.0 F10A/SK410 (1988-1998), SUZUKI JIMNY 1.3 M13A SN413V-2 DOHC, SUZUKI JIMNY 1.3 G13BB/SN413V (1999-2003), SUZUKI CARRY 1.3 G13B SOHC (2000-2006), SUZUKI GRAND NOMADE 1.9 F9Q/JB419 (2006-2013), SUZUKI GRAND VITARA 1.6 M16A/JB416 (2006-2010) Saber más

6 productos

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