Specialist supplier accompanying Clockmakers and Jewellers for five generations
Gift packaging - Special discounts
Learn more
SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_EN mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( tC.actif = 1 AND EN = 1 ) AND mPrix.CategorieProduit IN ('BA') AND tC.id_masterTrieurParent NOT IN (9,15) AND tC.id_masterGamme_LAVAL IN (14, 25) GROUP BY mPrix.id_masterPrix