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=120 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,