PT EN

 
Notícias
Em destaque

Promoções
FILTRO YAM GRIZZLY 660
 € 55.86 
 € 35.00  
FILTRO YAM GRIZZLY 660
FILTRO YAM BANSHEE350
 € 53.55 
 € 37.49  
FILTRO YAM BANSHEE350
FILTRO YAM RAPTOR660 01-05
 € 60.11 
 € 42.08  
FILTRO YAM RAPTOR660 01-05
FILTRO POL PREDATOR500 / TROY LEE 500
 € 53.25 
 € 37.28  
FILTRO POL PREDATOR500 / TROY LEE 500
UNI HOND CR125 89-01 / CR250 88-01 / CR500 89-02
 € 25.76 
 € 18.00  
UNI HOND CR125 89-01 / CR250 88-01 / CR500 89-02
UNI OLEO
 € 6.10 
 € 4.88  
UNI OLEO

VER TODAS AS PROMOÇÕES


Novidades
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by pd.products_name limit 6 limit 0, 100' at line 1

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '216' limit 6 order by pd.products_name limit 6 limit 0, 100

[TEP STOP]