EXPOSITORES Y ACCESORIOS 

SELECT * FROM selection_ES Selection INNER JOIN trieurCollection tC USING(id_masterPrix) INNER JOIN masterPrix mPrix ON mPrix.id_masterPrix = Selection.id_masterPrix INNER JOIN prix_ES mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit WHERE ( tC.actif = 1 AND ES = 1 ) AND Selection.id_masterSelection = 269 AND Selection.actif = 1 AND tC.id_masterTrieurParent NOT IN (9,15) GROUP BY mPrix.id_masterPrix