SELECT * FROM emission
WHERE idPolice IN (185,203)
AND codetypeAvenant="QTM";


SELECT 
codeSociete,id,libellePolice,
IFNULL(limiteConsommation,0) AS limiteConsommation
FROM police 
WHERE id IN (185,203);


SELECT tauxTaxeReduit  
FROM vw_taxe_police 
WHERE idPolice IN (185,203) LIMIT 1;




SELECT * FROM beneficiaire
WHERE idPolice IN (185,203)
AND nomBeneficiaire LIKE "%AVENANT%"


SELECT * FROM emission
WHERE idPolice IN (185,203)
AND codetypeAvenant="QTM";

CALL sp_supprimer_beneficiaire(26991,"lionel")

SELECT * FROM beneficiaire WHERE id=26991