money_off 5% de remise sur votre première commande money_off
local_shipping Livraison Gratuite A Plus De €80 local_shipping
monetization_on Retour Gratuit Sous 30 Jours monetization_on
flight LIVRAISON RAPIDE flight
local_shipping Garantie Prix Le Plus Bas local_shipping

Accueil

Outlet

storage
Trier Par: Prix : Croissantexpand_lessexpand_more
A la unePrix : DécroissantPrix : Croissant
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 'eau repellent~%' and pcoll.products_collection_id = cg.products_collection_id a' 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_collection pcoll, (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.3) 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 pcoll.products_collection LIKE '%~D\\'eau repellent~%' and pcoll.products_collection_id = cg.products_collection_id and c.categories_id IN(2,4,5,6,7,8,9,10,11,12,13,14,15,16) and cd.language_id='1' and c.categories_status='1' order by c.sort_order,cd.categories_id]