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

Ingresa tu
Vehículo
0
Carro 0
$0

SENSOR DE TEMPERATURA ADMISIóN

Compatible con:
    Compatible con:

7

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 (239862, 239823, 239822, 239821, 239820, 239819, 239818))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,239862,239823,239822,239821,239820,239819,239818)

7 productos

Fijar Dirección Descendente
Ver como Lista Parrilla
por página
  1. SENSOR TEMPERATURA AIRE - SUZUKI. Compatibilidades: SUZUKI IGNIS 1.3 M13A/RG413 2WD (2001-2006), SUZUKI IGNIS 1.3 M13A/RG413 4WD (2001-2006), SUZUKI WAGON R 1.0 K10A 5PTAS (1997-2000), SUZUKI GRAND NOMADE 2.5 H25A/SQ625 (1998-2006), SUZUKI GRAND NOMADE 2.0 J20A/SQ420 (1998-2005), SUZUKI MASTER VAN 1.3 G13BB/GA413 (1999-2006), SUZUKI GRAND VITARA 1.6 G16B/SQ416 (1998-2006), SUZUKI JIMNY 1.3 M13A SN413V-7 DOHC, SUZUKI JIMNY 1.3 M13A SN413V-9 DOHC, SUZUKI GRAND VITARA 2.0 J20A/SQ420 (1998-2005), SUZUKI IGNIS 1.2 K12M DOHC 16V, SUZUKI JIMNY 1.3 M13A/SN413V-6 DOHC (2006), SUZUKI JIMNY 1.3 M13A SN413V-2 DOHC, SUZUKI JIMNY 1.3 G13BB/SN413V (1999-2003), SUZUKI LIANA 1.6 M16A/RH416 DOHC (2001-2003), SUZUKI SX-4 1.6 SCROSS M16A/AKK416 DOHC (2015-2018), SUZUKI SX-4 2.0 Saber más
  2. SENSOR TEMPERATURA AIRE - SUZUKI. Compatibilidades: SUZUKI IGNIS 1.3 M13A/RG413 2WD (2001-2006), SUZUKI IGNIS 1.3 M13A/RG413 4WD (2001-2006), SUZUKI JIMNY 1.3 M13A SN413V-7 DOHC, SUZUKI JIMNY 1.3 M13A SN413V-9 DOHC, SUZUKI IGNIS 1.2 K12M DOHC 16V, SUZUKI JIMNY 1.3 M13A/SN413V-6 DOHC (2006), SUZUKI JIMNY 1.3 M13A SN413V-2 DOHC, SUZUKI JIMNY 1.3 G13BB/SN413V (1999-2003), SUZUKI SX-4 1.6 SCROSS M16A/AKK416 DOHC (2015-2018), SUZUKI SX-4 2.0 Saber más

7 productos

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