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 = '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
Tourne à gauche  1/12mm extracteur M1/M12
Tourne à gauche 1/12mm extracteur M1/M12
Ref. 911063
15,90 €
En savoir plus
Comparer
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
Porte filiere cage ø25,4mm à 5 vis de blocage
Porte filiere cage ø25,4mm à 5 vis de blocage
Ref. 911153
11,90 €
En savoir plus
Comparer
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
Coffret de 13 pièces tarauds et filières + clé
Coffret de 13 pièces tarauds et filières + clé
Ref. 982006
  • Usage : Courant
  • Conditionnement : x 13 pcs
29,90 €
En savoir plus
Comparer
Page 1 / 1