Fitness&ocasion Fitness Project Factory      
Condiciones de Uso Fabricantes Contáctenos Novedades Ofertas
  Top » Catalog Add to favorites |  Site Map  
2 3 2
 CARDIO MACHINES               Ellipticals    TreadMillers
 FREE WEIGHT   Banches    Bars    Discos    Dumbells    Handells    Racks
 SPARE PARTS   Cardio Machines    Indoor Cycling    Strength Machines
New Products For October






Schwinn Ic Pro
Schwinn Ic Pro

Pavigym Free Weight
Pavigym Free Weight
Star Product
1054 - Unknown column 'p.products_id' in 'on clause'

select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1'