money_off 5% Rabatt auf Ihre erste Bestellung money_off
local_shipping Kostenloser Versand Über €90 local_shipping
monetization_on 30 Tage Rückgaberecht monetization_on
flight Schnelle Lieferung flight
local_shipping Niedrigstpreisgarantie local_shipping

Startseite

Outlet

storage
Sortieren Nach: Ähnliche Artikelexpand_lessexpand_more
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 '?) and cd.language_id='1' and c.categories_status='1' order by c.sort_order,cd.c' at line 1
in:
[select distinct c.categories_id, cd.categories_name, cg.master_categories_id from categories c, categories_description cd, products cg, products_color pccg, products_size ps, (SELECT DISTINCT master_categories_id FROM (SELECT 1-s.specials_new_products_price/p.products_price as discount, p.products_id, p.products_sx_id, p.master_categories_id, COUNT(DISTINCT products_sx_id),IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price FROM products p left join specials s on p.products_id = s.products_id GROUP BY products_sx_id) psx WHERE psx.discount > 0.2) jx where c.categories_id=cd.categories_id and cg.master_categories_id=c.categories_id and jx.master_categories_id=c.categories_id and ps.products_size like '%~XXXL~%' and ps.products_size not like '%XXXL NO%' and cg.products_size_id = ps.products_size_id and pccg.products_color like '%Grün%' and cg.products_color_id = pccg.products_color_id and c.categories_id IN(12 ) and cd.language_id='1' and c.categories_status='1' order by c.sort_order,cd.categories_id]