--	DONNY - DEVIS EN COURS A PARTIR DE 2023
SELECT DISTINCT CLI.EMAIL AS 'EMAIL', ENT.TIERS 
FROM ENT ENT LEFT OUTER JOIN CLI CLI ON ENT.TIERS = CLI.TIERS
WHERE CLI.DOS = ENT.DOS AND ((ENT.TICOD='C') AND (ENT.DOS=1) AND (ENT.PICOD=1) AND (ENT.CE4='1') AND (ENT.DOS=1) AND (ENT.PICOD=1) AND (ENT.CE4='1')) AND CLI.EMAIL != '' AND (ENT.PIDT>'2023-01-01') AND CLI.REPR_0001 = 'ACS' 
UNION 
SELECT DISTINCT PRO.EMAIL AS 'EMAIL', ENT.TIERS 
FROM ENT ENT LEFT OUTER JOIN PRO PRO ON ENT.TIERS = PRO.TIERS
WHERE PRO.DOS = ENT.DOS AND ((ENT.TICOD='C') AND (ENT.DOS=1) AND (ENT.PICOD=1) AND (ENT.CE4='1') AND (ENT.DOS=1) AND (ENT.PICOD=1) AND (ENT.CE4='1')) AND PRO.EMAIL != '' AND (ENT.PIDT>'2023-01-01') AND PRO.REPR_0001 = 'ACS'