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 = '1600' AND _categories.id_categorieB = '1621' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 9
Box of 15 HSS screwbits LG25mm - intensive range
Ref. 130076
- Use : Intensif
- packaging : x 15 pcs
More about
Compare
Drywall special case 29 pcs Intensive use
Ref. 190176
- Use : Courant
- packaging : x 29 pcs
More about
Compare
Drills/screw bits case 32 pieces Intensive use
Ref. 190186
- Use : Intensive
- packaging : x 32 pcs
More about
Compare
Metal/wood 8 pieces drill case Intensive use
Ref. 190426
- Use : Intensif
- packaging : 8 pcs
More about
Compare
Metal/concrete/screw bits 37 pieces case Intensive use
Ref. 190596
- Use : Intensif
- packaging : x 37 pcs
More about
Compare
SDS+ 10 pieces case Intensive use
Ref. 190626
- Use : Intensif
- packaging : x 10 pcs
More about
Compare
Drill/screw bits case 108 pieces Current use
Ref. 190646
- Use : Courant
- packaging : x 108 pcs
More about
Compare
HSS metal drills 9 pieces case Intensive use
Ref. 911646
- Use : Intensif
- packaging : x 9 pcs
More about
Compare
HSS metal drills 19 pieces case Intensive use
Ref. 911656
- Use : Intensif
- packaging : x 19 pcs
More about
Compare