Comparer

Retrouvez les accessoires complémentaires compatibles avec les machines à bois PEUGEOT

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 = '2000' AND _categories.id_categorieB = '2012' GROUP BY _articles.id_article ORDER BY reference ASC LIMIT 0, 9
Array ( [id_prix] => 58 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 17.076051791667 [PTTC] => 20.49126215 [PTTC_offre] => 20,49 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 20.49126215 [QUANTITE_MAX] => 9 [affichage_prix] => 20,49 € [finale_price] => 20,49 )
1
Lame de scie à onglets manuelle 550 mm - 24TPI
Lame de scie à onglets manuelle 550 mm - 24TPI
Ref. 175237
  • Longueur : 550 MM
  • Nombre de dents : 24 TPI
20,49 €
En savoir plus
Comparer
Array ( [id_prix] => 60 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 21.579166666667 [PTTC] => 25.895 [PTTC_offre] => 25,89 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 25.895 [QUANTITE_MAX] => 43 [affichage_prix] => 25,89 € [finale_price] => 25,89 )
1
Lame de scie à onglets manuelle 600 mm - 24TPI
Lame de scie à onglets manuelle 600 mm - 24TPI
Ref. 175247
  • Longueur : 600 MM
  • Nombre de dents : 24 TPI
25,89 €
En savoir plus
Comparer
Array ( [id_prix] => 3669 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 24.794306916667 [PTTC] => 29.7531683 [PTTC_offre] => 29,75 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 29.7531683 [QUANTITE_MAX] => 81 [affichage_prix] => 29,75 € [finale_price] => 29,75 )
1
Lame à pastilles carbure Ø165mm-Alésage 20 mm-24T
Lame à pastilles carbure Ø165mm-Alésage 20 mm-24T
Ref. 801320
29,75 €
En savoir plus
Comparer
Array ( [id_prix] => 3670 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 26.713924791667 [PTTC] => 32.05670975 [PTTC_offre] => 32,06 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 32.05670975 [QUANTITE_MAX] => 94 [affichage_prix] => 32,06 € [finale_price] => 32,06 )
1
Lame à pastilles carbure Ø165mm-Alésage 20 mm-50T
Lame à pastilles carbure Ø165mm-Alésage 20 mm-50T
Ref. 801321
32,06 €
En savoir plus
Comparer
Array ( [id_prix] => 3976 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 27.700309666667 [PTTC] => 33.2403716 [PTTC_offre] => 33,24 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 33.2403716 [QUANTITE_MAX] => 59 [affichage_prix] => 33,24 € [finale_price] => 33,24 )
1
Lame à pastilles carbure Ø165mm-Alésage 20 mm-40T
Lame à pastilles carbure Ø165mm-Alésage 20 mm-40T
Ref. 801325
  • Diamètre : 165 MM
33,24 €
En savoir plus
Comparer
Array ( [id_prix] => 3671 [email] => [VEL] => 1 [id_categorieA] => 2000 [id_categorieB] => 2012 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 27.242019666667 [PTTC] => 32.6904236 [PTTC_offre] => 32,69 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 32.6904236 [QUANTITE_MAX] => 1 [affichage_prix] => 32,69 € [finale_price] => 32,69 )
1
Lame à pastilles carbure Ø210mm-Alésage 30 mm-40T
Lame à pastilles carbure Ø210mm-Alésage 30 mm-40T
Ref. 801334
32,69 €
En savoir plus
Comparer
Page 1 / 7