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

Ingresa tu
Vehículo
0
Carro 0
$0

KIA MOTORS

AVELLA
CADENZA
CAPITAL
1.8
CARENS
CARNIVAL
CEED
CERATO
CERES
CLARUS
COMBI
CREDOS
FAMILY
FAMILY-WAGON
1.3
FRONTIER
GRAND CARNIVAL
JOICE
2.0
K2400
K3
1.6
KOUP
LOTZE
2.0
MAGENTIS
MOHAVE
MORNING
NIRO
1.6
OPIRUS
OPTIMA
PICANTO
POP
PREGIO
PRIDE
QUORIS
RETONA
SELTOS
2.0
SEPHIA
SOUL
SPECTRA
SPORTAGE
STINGER
TELLURIDE
TOPIC
VENGA
X-TREK
2.0
AVELLA
CADENZA
CAPITAL
1.8
CARENS
CARNIVAL
CEED
CERATO
CERES
CLARUS
COMBI
CREDOS
FAMILY
FAMILY-WAGON
1.3
FRONTIER
GRAND CARNIVAL
JOICE
2.0
K2400
K3
1.6
KOUP
LOTZE
2.0
MAGENTIS
MOHAVE
MORNING
NIRO
1.6
OPIRUS
OPTIMA
PICANTO
POP
PREGIO
PRIDE
QUORIS
RETONA
SELTOS
2.0
SEPHIA
SOUL
SPECTRA
SPORTAGE
STINGER
TELLURIDE
TOPIC
VENGA
X-TREK
2.0
Compatible con:
    Compatible con:

Buscar por medida
    Buscar por medida

7343

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 (26759, 26756, 26754, 26734, 26732, 26729, 26727, 26724, 26721, 26720, 26717, 26716, 26715, 26707, 26706, 26703, 25103, 25102, 25101, 25100, 25099, 25098, 25097, 25096, 25095, 25094, 25092, 25091, 25090, 25089, 25088, 25087, 25086, 25082, 25081, 25077, 25076, 25074, 25073, 25072, 25071, 25070, 25069, 25068, 25067, 25066, 25065, 25064, 25063, 25062))) AND (e.created_in <= '1669604342') AND (e.updated_in > '1669604342') ORDER BY FIELD(e.entity_id,26759,26756,26754,26734,26732,26729,26727,26724,26721,26720,26717,26716,26715,26707,26706,26703,25103,25102,25101,25100,25099,25098,25097,25096,25095,25094,25092,25091,25090,25089,25088,25087,25086,25082,25081,25077,25076,25074,25073,25072,25071,25070,25069,25068,25067,25066,25065,25064,25063,25062)

Productos 1-50 de 7343

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

Productos 1-50 de 7343

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