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 _prix.stock > 5)
) AND _categories.id_categorieA = '1700' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 12
Corded renovator
ENERGYBRUSH-1500
Ref. 150610
- Power in CV : 1500 W
- abrasive diameter : 120 MM
- abrasive length : 100 MM
More about
Compare
STEEL BRASS COATED WIRE 0,3MM 120*100MM FOR 150610
Ref. 800301
More about
Compare
NYLON WIRE ABRASIVES COATED 120*100MM FOR 150610
Ref. 800302
More about
Compare
2* ABRASIVE FLAP WHEELS GRIT40 120*100MM FOR 150610
Ref. 800303
More about
Compare
2 *ABRASIVE FLAP WHEELS GRIT80 120*100MM FOR 150610
Ref. 800304
More about
Compare
2* ABRASIVE PAPER WHEEL GRIT40 120*100MM FOR 150610
Ref. 800305
More about
Compare
2* ABRASIVE PAPER WHEEL GRIT80 120*100MM FOR 150610
Ref. 800306
More about
Compare