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  
Bikes  Bikes
 BMX
BMX
 Childrens Bikes
Childrens Bikes
 Dual Sport
Dual Sport
 Electric Bikes
Electric Bikes
 Electric MTB
Electric MTB
 FAT Bikes
FAT Bikes
 Ladies Mountain Bike
Ladies Mountain Bike
 Mens Mountian Bikes
Mens Mountian Bikes
 Pashley
Pashley
 Traditional Bikes
Traditional 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 = '4' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

[TEP STOP]