Cart Contents (4)
Checkout
My Account
Top
»
Catalog
»
PARTS
»
12-0030
$199.99
Keys Fitness 8800 McMillan Drive Motor 3.0 HP 12-0030
[12-0030]
FREE DELIVERY !
Local Area
TEXT or CALL ... (972) 488-3222
or LOCAL STORE PICKUP for a Discount !
Order Online and choose "Check" at checkout then pay only for the goods upon receiving them.
Refurbished McMillan Drive Motor Part Number 12-0030
Fits the following treadmills:
Alliance
ALL880HR
ALL950HR-OB
Keys
8800
8800LI
A8T
Smooth
8.5P
8.8HRC
Add to Cart
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'fitness_osc23.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1906' and opa.orders_id = opb.orders_id and opb.products_id != '1906' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 15
[TEP STOP]