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)
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
Meule Corindon gris 150x20x13mm Grain 36
Ref. 800320
En savoir plus
Comparer
Meule Corindon gris 150x20x13 mm Grain 60
Ref. 800322
En savoir plus
Comparer
Meule Corindon gris 150x25x32 mm Grain 60 + bague
Ref. 800326
En savoir plus
Comparer
Meule Corindon blanc 150x20x13 mm Grain 60
Ref. 800350
En savoir plus
Comparer
Meule Carbure de silicium 150x20x32 mm Grain 120
Ref. 800362
En savoir plus
Comparer
Meule Corindon blanc 100x20x16 mm Grain 100
Ref. 800375
En savoir plus
Comparer
Meule Corindon blanc 200x40x20 mm Grain 180
Ref. 800377
En savoir plus
Comparer
Meule Corindon gris 200x36x20 mm Grain 96
Ref. 800378
En savoir plus
Comparer