Cycle Shop Hampshire Cycle Shop Andover Bike Shop Andover Justbikesandover Bmx Hampshire  Secure Credit Card Payments
Just Bikes (Andover)
103 High Street, Andover,
Hampshire, SP10 1ND.

Telephone: 01264 355982
  Home Special Offers Contact Us Create an Account Log In Cart Contents Checkout
  The Hampshire Cycle Experts
Ladies Mountain Bike  Ladies Mountain Bike
 27.5 inch wheels
27.5 inch wheels
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '90' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6