$sql = " SELECT m.id as id,m.nom as nom,m.descript as descript,st.prix as prix,(IFNULL(SUM(st.quantite), 0) - IFNULL(SUM(pa.nbr), 0)) as quantite,DATEDIFF(NOW(),st.date_mise_a_jour) as maj , p.id as idPharm, p.nom as nomPharm FROM stocks st INNER JOIN medicaments m ON m.id = st.id_medicaments INNER JOIN pharmacies p ON p.id = st.id_pharmacies LEFT JOIN ( paniers pa INNER JOIN transactions v ON pa.id_transactions = v.id AND v.statut = 1 ) ON pa.id_medicaments = m.id WHERE p.id = $id GROUP BY m.id ORDER BY quantite LIMIT $debut,$limit ";