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 = '1500' AND _categories.id_categorieB = '1522' GROUP BY _articles.id_article
ORDER BY reference ASC
LIMIT 0, 12
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
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
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
Charger - EnergyHub 18V
ENERGYHUB
Ref. 250625
More about
Compare
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
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