-- requete sur cp
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1171
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in (
'08001','08002','08003','08004','08005','08006','08007','08008','08009','08010','08011','08012','08013','08014','08015','08016','08017','08018','08019','08020','08021','08022','08023','08024','08025','08026','08027','08028','08029','08030','08031','08032','08033','08034','08035','08036','08037','08038','08039','08040','08041','08042','08070','08071','08075','08080','27666','07609','18517','08310','08911','08913','08915','08917','08214','08001','08003','08005','08007','08009','08011','08013','08015','08017','08019','08021','08023','08025','08027','08029','08031','08033','08035','08037','08039','08041','08070','08080','08859','08521','08211','08420','08420','08739','08761','08860','08290','08757','08520','08820','08187','08775','08320','08739','08754','08185','08790','08187','08187','08470','08739','08770','08753','08860','08790','08400','08402','08404','08734','08901','08903','08905','08907','08292','08105','08120','08430','08110','08194','08520','08230','08520','08185','08107','08230','08301','08303','08100','08390','08160','08795','08739','08317','08780','08150','08213','08330','08732','08200','08202','08204','08206','08208','08805','08757','08171','08173','08190','08196','08198','08211','08105','08719','08782','08960','08791','08192','08620','08922','08924','08630','08210','08329','08220','08222','08224','08226','08228','08629','08231','08233','08410','08232','08339','17420'
);
-- and substring(coregistration_valeur from 1 for 2) not in ();
-- on passe les lignes traités à 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 = 1171
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in (
'08001','08002','08003','08004','08005','08006','08007','08008','08009','08010','08011','08012','08013','08014','08015','08016','08017','08018','08019','08020','08021','08022','08023','08024','08025','08026','08027','08028','08029','08030','08031','08032','08033','08034','08035','08036','08037','08038','08039','08040','08041','08042','08070','08071','08075','08080','27666','07609','18517','08310','08911','08913','08915','08917','08214','08001','08003','08005','08007','08009','08011','08013','08015','08017','08019','08021','08023','08025','08027','08029','08031','08033','08035','08037','08039','08041','08070','08080','08859','08521','08211','08420','08420','08739','08761','08860','08290','08757','08520','08820','08187','08775','08320','08739','08754','08185','08790','08187','08187','08470','08739','08770','08753','08860','08790','08400','08402','08404','08734','08901','08903','08905','08907','08292','08105','08120','08430','08110','08194','08520','08230','08520','08185','08107','08230','08301','08303','08100','08390','08160','08795','08739','08317','08780','08150','08213','08330','08732','08200','08202','08204','08206','08208','08805','08757','08171','08173','08190','08196','08198','08211','08105','08719','08782','08960','08791','08192','08620','08922','08924','08630','08210','08329','08220','08222','08224','08226','08228','08629','08231','08233','08410','08232','08339','17420'
);
-- fin requete cp