For cutting, deburring, brushing, sanding and polishing simply and securely with Peugeot griners angles. 125 or 230 mm, with or without rotary handle make it easy on yourself!
SELECT _articles.*, _prix.* FROM _articles
INNER JOIN _prix ON _articles.id_article = _prix.id_article
INNER JOIN _categories ON _articles.id_article = _categories.id_article
LEFT OUTER JOIN _articles_forcingVEL AFVL ON AFVL.id_article = _articles.id_article
WHERE (
(_articles.actif = 1 AND _prix.actif = 1)
OR
(AFVL.actif = 1 AND AFVL.PTTC > 0 )
) AND _categories.id_categorieA = '1000' AND _categories.id_categorieB = '1007' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 9
No Item
Contact us Press The brand Products Customer Services Store Outlets The Blog Press area
Sign up to our newsletter to receive advice and learn all about your current or future Peugeot tools.