SELECT * FROM p_prestationactes
WHERE numeroFeuilleMaladie=48930   -- 38 452



SELECT * FROM  `garantiebeneficiaire`
WHERE numeroBeneficiaire="0185006501"
ORDER BY ordre





SELECT * FROM p_feuillemaladie
WHERE numeroFeuilleMaladie=48930

SELECT * FROM p_facture
WHERE numeroFeuilleMaladie=48930


SELECT * FROM p_prestationactes
WHERE YEAR(LEFT(dateSysteme,10))=2022
-- AND month(LEFT(dateSysteme,10))=3
AND montantApayer<0
AND idFacture>0
-- numeroFeuilleMaladie=38951


SELECT * FROM p_facture
WHERE YEAR(LEFT(dateSysteme,10))=2022
AND MONTH(LEFT(dateSysteme,10))=6
AND montantApayer<0



SELECT * FROM p_feuillemaladie
WHERE YEAR(LEFT(dateSysteme,10))=2022
AND MONTH(LEFT(dateSysteme,10))=9
AND montantArembourser<0