-- requete sur email
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1118
and coregistration_champ = 1
and coregistration_eligible = 1
and (
        coregistration_valeur like ('%@zoho.')
        or coregistration_valeur like ('%@.eu')
        -- or coregistration_valeur like ('%@yopmail.%')
);
-- on passe les lignes traitees a exportable 3 pour ne plus les selectionner
update coregistration.coregistration set coregistration_eligible = 3
where coregistration_coregistration_affichage in
(
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1118
and coregistration_champ = 1
and coregistration_eligible = 1
and (
        coregistration_valeur like ('%@zoho.')
        or coregistration_valeur like ('%@.eu')
        -- or coregistration_valeur like ('%@yopmail.%')
)
);