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 AND _prix.critere1 = 1)
OR
(AFVL.actif = 1 AND AFVL.PTTC > 0 AND _prix.stock > 5 )
) AND _categories.id_categorieA = '1600' AND _categories.id_categorieB = '1621' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 12
Box of 15 HSS screwbits LG25mm - intensive range
Ref. 130076
- Use : Intensif
- packaging : x 15 pcs
14,90 €
More about
Compare
Drills/screw bits case 32 pieces Intensive use
Ref. 190186
- Use : Intensive
- packaging : x 32 pcs
39,90 €
More about
Compare
Metal/wood 8 pieces drill case Intensive use
Ref. 190426
- Use : Intensif
- packaging : 8 pcs
22,90 €
More about
Compare
Metal/concrete/screw bits 37 pieces case Intensive use
Ref. 190596
- Use : Intensif
- packaging : x 37 pcs
43,90 €
More about
Compare
SDS+ 10 pieces case Intensive use
Ref. 190626
- Use : Intensif
- packaging : x 10 pcs
35,90 €
More about
Compare
Drill/screw bits case 108 pieces Current use
Ref. 190646
- Use : Courant
- packaging : x 108 pcs
49,90 €
More about
Compare
HSS metal drills 9 pieces case Intensive use
Ref. 911646
- Use : Intensif
- packaging : x 9 pcs
19,50 €
More about
Compare
HSS metal drills 19 pieces case Intensive use
Ref. 911656
- Use : Intensif
- packaging : x 19 pcs
32,90 €
More about
Compare
Concrete drills 5 pieces case Intensive use
Ref. 915566
- Use : Intensif
- packaging : x 5 pcs
20,90 €
More about
Compare
Concrete drills 8 pieces case intensive use
Ref. 915576
- Use : Intensif
- packaging : x 8 pcs
25,90 €
More about
Compare
Wood brad point drills 6 pieces case Intensive use
Ref. 917006
- Use : Intensif
- packaging : x 6 pcs
13,50 €
More about
Compare
Wood brad point drills 10 pieces case Intensive use
Ref. 917016
- Use : Intensif
- packaging : x 10 pcs
18,90 €
More about
Compare