Store Front » Royal Enfield » Royal Enfield UCE C5/Classic 09- » 05S-090

Account Info  |  Cart Contents  |  Checkout

Categories Fork Oil (5) Buell-> (9) BMW-> (5) Ducati-> (65) Harley-> (7) Honda-> (196) Kawasaki-> (169) Moto Guzzi-> (6) MZ-> (1) Royal Enfield-> (6)   Royal Enfield UCE C5/Classic 09- (6) Suzuki-> (225) Triumph-> (72) Yamaha-> (179) Custom (5) Information Find Your Spring Rate Warranties & Returns Contact Us About Us Tech Articles Ride Reports Privacy Policy

Royal Enfield UCE C5/Classic 09-12 - 0.90kg/mm Sonic Springs [05S-090] $79.95 This product was added to our catalog on Friday 27 April, 2012. 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '963' and opa.orders_id = opb.orders_id and opb.products_id != '963' 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 6 [TEP STOP]