Nederlands Deutsch English Inloggen  |  Inhoud winkelwagen  |  Afrekenen  |  Home   
Hoofdpagina » Uitgebreid zoeken » Zoekresultaat
Categorieën
Aanbiedingen
Aanhanger
Autoaccessoires
Cadeau artikelen
Cockpit uitrusting
Elektronica
Grond equipment
Installatiematerialen
Instrumenten
Kleding & verzorging
Lieren / Sleep toebehoren
Vliegtuig onderhoud
Vliegtuig tuning
Snel zoeken
Fabrikanten
Informatie
Bestellen
Betalen
Verzending
Over deze site
Openingstijden
Over ons
Neem contact op
Betaalmogelijkheden
Slideshow
Artikelen die aan de zoekcriteria voldoen
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct p.products_image, m.manufacturers_id, p.products_id, pd.product' at line 1

select count(distinct p.products_id) as total select distinct p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_sales_status, 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 final_price , pd.products_namefrom products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, 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 = c.categories_id and ((pd.products_name like '%garrecht%' or p.products_model like '%garrecht%' or m.manufacturers_name like '%garrecht%' or pd.products_description like '%garrecht%') )

[TEP STOP]