-- requetes pour avoir la liste des campagnes coreg
select distinct coregistration_affichage_campagne_annonceur
from coregistration.coregistration_affichage
inner join fdw_vipconcours.membre_tmp on coregistration_affichage_email = email 
where coregistration_affichage_site = 26
and coregistration_affichage_affilie = 134
and coregistration_affichage_date >= :date_debut
and coregistration_affichage_date < :date_fin
and coregistration_affichage_production is true;