-- requete sur cp
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 905
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('76600', '76310', '76290', '76430', '76930', '76700', '14600', '14130', '27210', '27680', '76280', '76210', '76110', '76133', '76170', '76790', '76610', '76620');
-- 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 = 905
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('76600', '76310', '76290', '76430', '76930', '76700', '14600', '14130', '27210', '27680', '76280', '76210', '76110', '76133', '76170', '76790', '76610', '76620')
);
-- fin requete cp