-- 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 = 824
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('44000', '44100', '44200', '44300', '44230', '44400', '44120', '44840', '44140', '44190', '44690', '44340', '44860', '44118', '44830', '44610', '44640', '44620', '44800', '44700');
-- 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 = 824
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('44000', '44100', '44200', '44300', '44230', '44400', '44120', '44840', '44140', '44190', '44690', '44340', '44860', '44118', '44830', '44610', '44640', '44620', '44800', '44700')
);
-- fin requete cp