SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_DE mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( tC.actif = 1 AND DE = 1 ) AND tC.id_masterTrieurParent NOT IN (9,15) AND tC.id_masterGamme_LAVAL IN (3, 9, 13) AND (mPrix.date_online BETWEEN DATE_SUB(CURDATE(), INTERVAL 180 DAY) AND CURDATE()) GROUP BY mPrix.id_masterPrix
Zu Favoriten hinzufügen