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

Account Info  |  Cart Contents  |  Checkout

Categories Fork Oil (5) Buell-> (9) BMW-> (5) Ducati-> (65) Harley-> (7) Honda-> (203) Kawasaki-> (169) Moto Guzzi-> (11) 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 - 1.00kg/mm Sonic Springs [05S-100] $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 = '964' and opa.orders_id = opb.orders_id and opb.products_id != '964' 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]