Comparer

Lames, meules de rechange 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 = '2500' AND _categories.id_categorieB = '2510' GROUP BY _articles.id_article ORDER BY reference ASC LIMIT 0, 9
Array ( [id_prix] => 66 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 23.434166666667 [PTTC] => 28.121 [PTTC_offre] => 28,12 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 28.121 [QUANTITE_MAX] => 274 [affichage_prix] => 28,12 € [finale_price] => 28,12 )
1
Meule Corindon gris 150x20x13mm Grain 36
Meule Corindon gris 150x20x13mm Grain 36
Ref. 800320
28,12 €
En savoir plus
Comparer
Array ( [id_prix] => 67 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 23.435916666667 [PTTC] => 28.1231 [PTTC_offre] => 28,12 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 28.1231 [QUANTITE_MAX] => 73 [affichage_prix] => 28,12 € [finale_price] => 28,12 )
1
Meule Corindon gris 150x20x13 mm Grain 60
Meule Corindon gris 150x20x13 mm Grain 60
Ref. 800322
28,12 €
En savoir plus
Comparer
Array ( [id_prix] => 68 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 33.636229166667 [PTTC] => 40.363475 [PTTC_offre] => 40,36 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 40.363475 [QUANTITE_MAX] => 52 [affichage_prix] => 40,36 € [finale_price] => 40,36 )
1
Meule Corindon gris 150x25x32 mm Grain 60 + bague
Meule Corindon gris 150x25x32 mm Grain 60 + bague
Ref. 800326
40,36 €
En savoir plus
Comparer
Array ( [id_prix] => 69 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 27.479729166667 [PTTC] => 32.975675 [PTTC_offre] => 32,98 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 32.975675 [QUANTITE_MAX] => 34 [affichage_prix] => 32,98 € [finale_price] => 32,98 )
1
Meule Corindon blanc 150x20x13 mm Grain 60
Meule Corindon blanc 150x20x13 mm Grain 60
Ref. 800350
32,98 €
En savoir plus
Comparer
Array ( [id_prix] => 70 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 31.877916666667 [PTTC] => 38.2535 [PTTC_offre] => 38,25 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 38.2535 [QUANTITE_MAX] => 203 [affichage_prix] => 38,25 € [finale_price] => 38,25 )
1
Meule Carbure de silicium 150x20x32 mm Grain 120
Meule Carbure de silicium 150x20x32 mm Grain 120
Ref. 800362
38,25 €
En savoir plus
Comparer
Array ( [id_prix] => 71 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 15.523291666667 [PTTC] => 18.62795 [PTTC_offre] => 18,63 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 18.62795 [QUANTITE_MAX] => 62 [affichage_prix] => 18,63 € [finale_price] => 18,63 )
1
Meule Corindon blanc 100x20x16 mm Grain 100
Meule Corindon blanc 100x20x16 mm Grain 100
Ref. 800375
18,63 €
En savoir plus
Comparer
Array ( [id_prix] => 72 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 49.893291666667 [PTTC] => 59.87195 [PTTC_offre] => 59,87 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 59.87195 [QUANTITE_MAX] => 65 [affichage_prix] => 59,87 € [finale_price] => 59,87 )
1
Meule Corindon blanc 200x40x20 mm Grain 180
Meule Corindon blanc 200x40x20 mm Grain 180
Ref. 800377
59,87 €
En savoir plus
Comparer
Array ( [id_prix] => 73 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 32.228441666667 [PTTC] => 38.67413 [PTTC_offre] => 38,67 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 38.67413 [QUANTITE_MAX] => 40 [affichage_prix] => 38,67 € [finale_price] => 38,67 )
1
Meule Corindon gris 200x36x20 mm Grain 96
Meule Corindon gris 200x36x20 mm Grain 96
Ref. 800378
38,67 €
En savoir plus
Comparer
Array ( [id_prix] => 74 [email] => [VEL] => 1 [id_categorieA] => 2500 [id_categorieB] => 2510 [FORCING_CAT] => 1 [FORCING_TYPE_ARTICLE] => 1 [PHT_fr] => 28.709804166667 [PTTC] => 34.451765 [PTTC_offre] => 34,45 [error_texte] => [critere1] => 1 [WS] => 1 [WS_PRICE] => 34.451765 [QUANTITE_MAX] => 20 [affichage_prix] => 34,45 € [finale_price] => 34,45 )
1
Meule à morfiler 190x28x10 mm
Meule à morfiler 190x28x10 mm
Ref. 800384
34,45 €
En savoir plus
Comparer
Page 1 / 2