SELECT DISTINCT A.IDType, A.IDGenerique, M.Marque, TRIM(T.Modele) AS Modele, A.Promo, A.PrixTTC, A.PrixPromo, A.Brade, A.DFP, A.TxPromo, A.GaucheDroite, A.TxTVA, SUM(P.QstockCalc), COUNT(P.IDPrecis) AS NbP FROM articlegenerique A, marque M, artlib T, articleprecis P WHERE P.IDGenerique=A.IDGenerique AND M.IDMarque=A.IDMarque AND T.IDLangue=2 AND T.IDGenerique=A.IDGenerique AND A.Valid=1 AND A.IDRubrique=132 GROUP BY A.IDGenerique, M.Marque, TRIM(T.Modele), A.Promo, A.PrixTTC, A.PrixPromo, A.Brade, A.DFP, A.GaucheDroite ORDER BY A.IDType, TRIM(T.Modele), A.GaucheDroite, A.IDGenerique DESC LIMIT 0,