insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 1309
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur like ('75%')
		or coregistration_valeur  like ('93400')
		or coregistration_valeur  like ('92110')
		or coregistration_valeur  like ('92200')
		or coregistration_valeur  like ('92300')
		or coregistration_valeur  like ('93260')
		or coregistration_valeur  like ('20000')
		or coregistration_valeur  like ('971')
		or coregistration_valeur  like ('973')
		or coregistration_valeur  like ('975')
		or coregistration_valeur  like ('972')
		or coregistration_valeur  like ('972')
		or coregistration_valeur  like ('976')
		or coregistration_valeur  like ('984')
		or coregistration_valeur  like ('987')
		or coregistration_valeur  like ('986')
		or coregistration_valeur  like ('988')
        -- or coregistration_valeur like ('%@yopmail.%')
);
-- on passe les lignes traitees a exportable 3 pour ne plus les selectionner
update coregistration set coregistration_eligible = 3
where coregistration_coregistration_affichage in
(
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 1309
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur  like ('75%')
		or coregistration_valeur  like ('93400')
		or coregistration_valeur  like ('92110')
		or coregistration_valeur  like ('92200')
		or coregistration_valeur  like ('92300')
		or coregistration_valeur  like ('93260')
		or coregistration_valeur  like ('20000')
		or coregistration_valeur  like ('971')
		or coregistration_valeur  like ('973')
		or coregistration_valeur  like ('975')
		or coregistration_valeur  like ('972')
		or coregistration_valeur  like ('972')
		or coregistration_valeur  like ('976')
		or coregistration_valeur  like ('984')
		or coregistration_valeur  like ('987')
		or coregistration_valeur  like ('986')
		or coregistration_valeur  like ('988')
)
);