Compare

The cordless powertools to work freely.

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 = '1522' GROUP BY _articles.id_article ORDER BY reference ASC LIMIT 0, 9
Array ( [VEL] => 1 )
1
2,0Ah Battery pack - EnergyHub 18V
2,0Ah Battery pack - EnergyHub 18V
ENERGYHUB-18V20
Ref. 250601
  • tension : 18 V
  • battery amperage : 2 AH
  • type of battery : Lithium-Ion
More about
Compare
Array ( [VEL] => 1 )
1
4,0Ah Battery pack - EnergyHub 18V
4,0Ah Battery pack - EnergyHub 18V
ENERGYHUB-18V40
Ref. 250602
  • tension : 18 V
  • battery amperage : 4 AH
  • type of battery : Lithium-Ion
More about
Compare
Array ( [VEL] => 1 )
1
5,0Ah Battery pack - EnergyHub 18V
5,0Ah Battery pack - EnergyHub 18V
ENERGYHUB-18V50
Ref. 250603
  • tension : 18 V
  • battery amperage : 5 AH
  • type of battery : Lithium-Ion
More about
Compare
Array ( [VEL] => 1 )
1
Charger - EnergyHub 18V
Charger - EnergyHub 18V
ENERGYHUB
Ref. 250625
  • tension : 18 V
More about
Compare
Array ( [VEL] => 1 )
1
Pack of 2,0Ah Battery pack + charger - EnergyHub 18V
Pack of 2,0Ah Battery pack + charger - EnergyHub 18V
ENERGYHUB-20
Ref. 250630
  • tension : 18 V
  • battery amperage : 2 AH
  • type of battery : Li-ion
More about
Compare
Array ( [VEL] => 1 )
1
Pack of 5,0Ah Battery pack + charger - EnergyHub 18V
Pack of 5,0Ah Battery pack + charger - EnergyHub 18V
ENERGYHUB-50
Ref. 250631
  • tension : 18 V
  • battery amperage : 5 AH
  • type of battery : Li-ion
More about
Compare
Page 1 / 1