1054 - Unknown column 'sp.remise' in 'where clause'
SELECT distinct(p.products_id)
FROM products_to_categories ptc, categories c , stock s, products p
WHERE
(p.products_status=1 AND (p.forcage_status =1 OR (p.forcage_status =0 AND s.product_quantity >0)))
AND p.products_id = ptc.products_id
AND s.product_id = p.products_id
AND c.categories_id = ptc.categories_id
AND p.manufacturers_id =274 AND sp.remise BETWEEN 40 AND 100
Le Bien-être Bio
Diss - Lit bébé à barreaux, 60x120 en fer forgé...
Diss - Lit enfant 3 côtés 90x200, Collection Ju...
Diss - Lit bébé à barreaux, 60x120 en fer forgé...