insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1688
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur  not in ('94140','94110','92600','93300','92220','93170','92270','92100','92340','94230','94220','92320','92140','92110','92700','92400','92260','92380','94250','92130','94200','92250','94270','93310','93260','92300','94700','92240','92190','93100','92120','92000','92200','93500','75001','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','92800','92500','92210','93200','94160','94410','93400','92330','92310','92150','92170','92420','94800','92390','94300','94400')
);
-- 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 = 1688
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur  not in ('94140','94110','92600','93300','92220','93170','92270','92100','92340','94230','94220','92320','92140','92110','92700','92400','92260','92380','94250','92130','94200','92250','94270','93310','93260','92300','94700','92240','92190','93100','92120','92000','92200','93500','75001','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','92800','92500','92210','93200','94160','94410','93400','92330','92310','92150','92170','92420','94800','92390','94300','94400')
));