stock paniers transactions

$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
";