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.416666666667 [PTTC] => 19.7 [PTTC_offre] => 14,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 19.7 [QUANTITE_MAX] => 82 [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] => 38.291666666667 [PTTC] => 45.95 [PTTC_offre] => 39,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 45.95 [QUANTITE_MAX] => 157 [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] => 23.416666666667 [PTTC] => 28.1 [PTTC_offre] => 22,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 28.1 [QUANTITE_MAX] => 317 [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] => 41.791666666667 [PTTC] => 50.15 [PTTC_offre] => 43,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 50.15 [QUANTITE_MAX] => 584 [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] => 34.791666666667 [PTTC] => 41.75 [PTTC_offre] => 35,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 41.75 [QUANTITE_MAX] => 116 [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] => 47.041666666667 [PTTC] => 56.45 [PTTC_offre] => 49,90 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 56.45 [QUANTITE_MAX] => 78 [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] => 20.704166666667 [PTTC] => 24.845 [PTTC_offre] => 19,50 [error_texte] => [critere1] => 0 [WS] => 1 [WS_PRICE] => 24.845 [QUANTITE_MAX] => 164 [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
Page 1 / 2