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
Search: 
 
  
Manufacturers: 
  
   Categories  
Childrens Bikes  Childrens Bikes
 12 inch wheels
12 inch wheels
 14 inch wheels
14 inch wheels
 16 inch wheels
16 inch wheels
 20 inch wheels
20 inch wheels
 24 inch wheels
24 inch wheels
 26 Inch wheels
26 Inch wheels
 Childrens Road / Cyclocross
Childrens Road / Cyclocross
 Balance Bikes
Balance Bikes
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 = '48' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

[TEP STOP]