Comparer

Perçage et vissage : des accessoires de haute qualité

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 = '1621' GROUP BY _articles.id_article ORDER BY reference ASC LIMIT 0, 9
Array ( [id_prix] => 3717 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [PHT_fr] => 16.854166666667 [PTTC] => 20.225 [PTTC_offre] => 14,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 20.225 [QUANTITE_MAX] => 37 [affichage_prix] => 14,90 € [finale_price] => 14,90 )
1
Coffret 15 embouts de vissage HSS LG25mm intensif
Coffret 15 embouts de vissage HSS LG25mm intensif
Ref. 130076
  • Usage : Intensif
  • Conditionnement : x 15 pcs
14,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3719 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [PHT_fr] => 39.753533541667 [PTTC] => 47.70424025 [PTTC_offre] => 39,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 47.70424025 [QUANTITE_MAX] => 130 [affichage_prix] => 39,90 € [finale_price] => 39,90 )
1
Coffret  mixte forets/embouts 32 pcs us. intensif
Coffret mixte forets/embouts 32 pcs us. intensif
Ref. 190186
  • Usage : Intensive
  • Conditionnement : x 32 pcs
39,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3720 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [PHT_fr] => 24.083762291667 [PTTC] => 28.90051475 [PTTC_offre] => 22,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 28.90051475 [QUANTITE_MAX] => 290 [affichage_prix] => 22,90 € [finale_price] => 22,90 )
1
Coffret mixte bois métal perçage 8 pcs  intensif
Coffret mixte bois métal perçage 8 pcs intensif
Ref. 190426
  • Usage : Intensif
  • Conditionnement : 8 pcs
22,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3721 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [PHT_fr] => 43.324136416667 [PTTC] => 51.9889637 [PTTC_offre] => 43,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 51.9889637 [QUANTITE_MAX] => 571 [affichage_prix] => 43,90 € [finale_price] => 43,90 )
1
Coffret 37 pièces métal/béton/vissage Intensif
Coffret 37 pièces métal/béton/vissage Intensif
Ref. 190596
  • Usage : Intensif
  • Conditionnement : x 37 pcs
43,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3722 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 35.955311666667 [PTTC] => 43.146374 [PTTC_offre] => 35,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 43.146374 [QUANTITE_MAX] => 206 [affichage_prix] => 35,90 € [finale_price] => 35,90 )
1
Coffret forets SDS + 10 pcs usage intensif
Coffret forets SDS + 10 pcs usage intensif
Ref. 190626
  • Usage : Intensif
  • Conditionnement : x 10 pcs
35,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3723 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [PHT_fr] => 48.913357291667 [PTTC] => 58.69602875 [PTTC_offre] => 49,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 58.69602875 [QUANTITE_MAX] => 9 [affichage_prix] => 49,90 € [finale_price] => 49,90 )
1
Mallette mixte forets/embouts 108 pcs Us. courant
Mallette mixte forets/embouts 108 pcs Us. courant
Ref. 190646
  • Usage : Courant
  • Conditionnement : x 108 pcs
49,90 €
En savoir plus
Comparer
Array ( [id_prix] => 3724 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 21.229143916667 [PTTC] => 25.4749727 [PTTC_offre] => 19,50 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 25.4749727 [QUANTITE_MAX] => 109 [affichage_prix] => 19,50 € [finale_price] => 19,50 )
1
Coffret de 9 forets métal HSS usage intensif
Coffret de 9 forets métal HSS usage intensif
Ref. 911646
  • Usage : Intensif
  • Conditionnement : x 9 pcs
19,50 €
En savoir plus
Comparer
Array ( [id_prix] => 3725 [email] => [VEL] => 1 [id_categorieA] => 1600 [id_categorieB] => 1621 [FORCING] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 33.212272416667 [PTTC] => 39.8547269 [PTTC_offre] => 32,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 39.8547269 [QUANTITE_MAX] => 259 [affichage_prix] => 32,90 € [finale_price] => 32,90 )
1
Coffret de 19 forets métal HSS Usage intensif
Coffret de 19 forets métal HSS Usage intensif
Ref. 911656
  • Usage : Intensif
  • Conditionnement : x 19 pcs
32,90 €
En savoir plus
Comparer
Page 1 / 2