9 341,00 €
SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (`e`.`entity_id` IN('667', '79', '90', '731', '928', '988', '31')) AND (stock_status_index.stock_status = 1) ORDER BY `entity_id` DESC
LIMIT 20
Nos meilleures ventes
RGK OCTANE SUB4 - Fauteuil roulant rigide en titane
A partir de
PAIRE DE FREINS CISEAUX EN ALUMINIUM - ACCESSOIRE POUR FAUTEUIL ROULANT
97,06 €
TRIRIDE MAD MAX - ROUE AVANT ÉLECTRIQUE POUR FAUTEUIL ROULANT
A partir de
6 489,00 €
TRIRIDE T-ROCKS - ROUE AVANT ÉLECTRIQUE POUR FAUTEUIL ROULANT
6 963,00 €
RGK TIGA FX - Fauteuil roulant rigide et pliant en aluminium
A partir de
6 328,00 €
RGK TIGA F2 - Fauteuil roulant rigide en aluminium ou titane
A partir de
3 656,00 €
RGK ELITE - Fauteuil roulant multisports en aluminium
A partir de
5 709,00 €
0 SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (`e`.`entity_id` IN('')) AND (stock_status_index.stock_status = 1) ORDER BY `entity_id` DESC
LIMIT 20
SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (`e`.`entity_id` IN('1304')) AND (stock_status_index.stock_status = 1) ORDER BY `entity_id` DESC
LIMIT 20
