SELECT products.id,products.part_no, products.part_name, products.image, products.catalog_no, products.slug, products.part_description, products.upc_code, products.used_catalog_no, products.used_upc_code, products.attributes, products.price, products.quantity, products.thumbnail_img, products.picture_new, products.picture_used, products.part_list_key, products.meta_title, products.meta_description, products.sort_order, products.active, products.model_specification, products.model_specification2, products.notes, products.quantity_on_model,products.photo, products.used_flg, COUNT(parts_used.id) AS used_available, (SELECT COUNT(parts_used.id) FROM parts_used WHERE reference_part_no = products.part_no AND quantity > 0 AND price > 0) AS used_stock FROM products LEFT JOIN parts_used ON(products.part_no=parts_used.reference_part_no) WHERE 1 AND products.is_duplicate = 0 AND ( ( find_in_set('831.248250', TRIM(products.model_specification) ) <> 0 OR find_in_set(' 831.248250', TRIM(products.model_specification2) ) <> 0 )OR ( find_in_set('SOFTRIDER', REPLACE(REPLACE(REPLACE(REPLACE(TRIM(products.model_specification), '(', '' ) , ')' , ''), ', ', ','), ', ', ',' ) ) ) AND find_in_set('831.248250', REPLACE(REPLACE(REPLACE(REPLACE(TRIM(products.model_specification2), '(', '' ) , ')' , ''), ', ', ','), ', ', ',' ) ) <> 0 OR find_in_set('SOFTRIDER', REPLACE(REPLACE(REPLACE(REPLACE(TRIM(products.model_specification), '(', '' ) , ')' , ''), ', ', ','), ', ', ',' ) ) <> 0 AND find_in_set('831.248250', REPLACE(REPLACE(REPLACE(REPLACE(TRIM(products.model_specification), '(', '' ) , ')' , ''), ', ', ','), ', ', ',' ) ) <> 0 or (products.model_specification = 'SOFTRIDER' AND products.model_specification2 = '') or (products.model_specification = '831.248250' AND products.model_specification2 = '') OR find_in_set('SOFTRIDER', REPLACE(REPLACE(REPLACE(REPLACE(TRIM(products.model_specification), '(', '' ) , ')' , ''), ', ', ','), ', ', ',' ) ) <> 0 ) AND products.manufacturer = 'Icon Health & Fitness' GROUP BY products.id
Brand: HEALTH RIDER
Category: Residential Treadmills
Type: Folding Treadmill
Model Name: SOFTRIDER
"Used Only" - contact us if interested in used or refurbished parts. Send us mail:
XImage | Catalog # | MPN | Part List Key | Quantity On Model | Part Description | Notes | Available Used | Model Compatibility List | New price | ||
---|---|---|---|---|---|---|---|---|---|---|---|
No Part Available |