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 = '1500' AND _categories.id_categorieB = '1520' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 9
18V Brushless rotary hammer
ENERGYPUNCH-18VBL
Ref. 250331
- tension : 18 V
- number of batteries : 0
- electronic variable speed :
More about
Compare
18V jig saw
ENERGYSAW-J18V
Ref. 250341
- tension : 18 V
- number of batteries : 0
- electronic variable speed :
More about
Compare
18V Brushless 165 mm circular saw
ENERGYSAW-C18VBL
Ref. 250351
- tension : 18 V
- number of batteries : 0
- rotary speed : 4200 TR/MIN
More about
Compare
18V 125 mm orbital sander
ENERGYSAND-18V
Ref. 250361
- tension : 18 V
- number of batteries : 0
- diameter : 125 MM
More about
Compare
18V Brushless 125 mm angle grinder
ENERGYGRIND-18VBL
Ref. 250371
- tension : 18 V
- number of batteries : 0
- electronic variable speed :
More about
Compare
18V Brushless renovator
ENERGYBRUSH-18VBL
Ref. 250381
- tension : 18 V
- type of battery : Lithiuim-Ion
- electronic variable speed :
More about
Compare
18V multitools
ENERGYTOOL-18V
Ref. 250391
- tension : 18 V
- electronic variable speed :
- hitting rate : 9000-19000 CPS/MIN
More about
Compare
ENERGYMIX-18VBL
Ref. 250431
- tension : 18 V
- type of battery : Li-ion
- number of batteries : 0
More about
Compare
ENERGYSHINE-18VBL
Ref. 250435
- tension : 18 V
- type of battery : Li-ion
- number of batteries : 0
More about
Compare