-- requete sur sous question
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_reponse_affichage
from coregistration.coregistration_reponse
inner join coregistration.coregistration on coregistration_coregistration_affichage = coregistration_reponse_affichage 
where coregistration_reponse_id_question = 523
and coregistration_champ = 1
and coregistration_campagne_annonceur = 765
and coregistration_reponse_id_reponse not similar to '06________'
and coregistration_reponse_id_reponse not similar to '07________'
and coregistration_eligible = 1;

-- on passe les lignes traités à exportable 3 pour ne plus les selectionner
update coregistration set coregistration_eligible = 3
where coregistration_coregistration_affichage in
(
select coregistration_reponse_affichage
from coregistration.coregistration_reponse
inner join coregistration.coregistration on coregistration_coregistration_affichage = coregistration_reponse_affichage
where coregistration_reponse_id_question = 523
and coregistration_champ = 1
and coregistration_campagne_annonceur = 765
and coregistration_reponse_id_reponse not similar to '06________'
and coregistration_reponse_id_reponse not similar to '07________'
and coregistration_eligible = 1
);
-- fin requete sous question