Compare

Find our Peugeot powertools range: Hammer system drills, angle grinders, sanders, saws ...

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 _categories.id_categorieA = '1600' AND _categories.id_categorieB = '1635' GROUP BY _articles.id_article ORDER BY reference ASC LIMIT 0, 9
Array ( [id_prix] => 3891 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1635 [FORCING] => 1 [PHT_fr] => 17.729166666667 [PTTC] => 21.275 [PTTC_offre] => 15,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 21.275 [QUANTITE_MAX] => 378 [affichage_prix] => 15,90 € [finale_price] => 15,90 )
1
Tap wrench 1/12 mm extractor
Tap wrench 1/12 mm extractor
Ref. 911063
15,90 €
More about
Compare
Array ( [id_prix] => 3892 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1635 [FORCING] => 1 [PHT_fr] => 14.054166666667 [PTTC] => 16.865 [PTTC_offre] => 11,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 16.865 [QUANTITE_MAX] => 214 [affichage_prix] => 11,90 € [finale_price] => 11,90 )
1
Die wrench 25x9 mm
Die wrench 25x9 mm
Ref. 911153
11,90 €
More about
Compare
Array ( [id_prix] => 3733 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1635 [FORCING] => 1 [PHT_fr] => 29.541666666667 [PTTC] => 35.45 [PTTC_offre] => 29,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 35.45 [QUANTITE_MAX] => 39 [affichage_prix] => 29,90 € [finale_price] => 29,90 )
1
Taps 13 pieces case + holder Current use
Taps 13 pieces case + holder Current use
Ref. 982006
  • Use : Courant
  • packaging : x 13 pcs
29,90 €
More about
Compare
Page 1 / 1