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 =350 AND c.categories_id = 895 AND sp.remise BETWEEN 30 AND 39.99
[TEP STOP]
Le Bien-être Bio
