JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

35350-300-aft Banjobout M10*1,25 met Remlichtschakelaar
Heb je maar 1 remleiding naar je voorrem, en geen verdeelstukje, dan is dit de oplossing voor de remlichtschakelaar.
1054 - Unknown column 'm.manufacturers_name' in 'order clause'

select p.products_id, pd.products_name, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = '750' order by m.manufacturers_name , pd.products_name