-- requete sur sous question en fonction question_id / reponse_id et campagne_annonceur_id
-- 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 and coregistration_champ = 1 -- jointure sur candeg
-- inner join coregistration.association_coregistration_question on association_coregistration_question_id_question = coregistration_reponse_id_question
-- where coregistration_reponse_id_question = 1163
-- and coregistration_reponse_id_reponse in ('3664')
-- and coregistration_campagne_annonceur = 1651
-- and coregistration_eligible = 1;
-- on passe les lignes traités à refuse hands ciblage 3 pour ne plus les selectionner
-- update coregistration.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 and coregistration_champ = 1 -- jointure sur candeg
-- inner join coregistration.association_coregistration_question on association_coregistration_question_id_question = coregistration_reponse_id_question
-- where coregistration_reponse_id_question = 1163
-- and coregistration_reponse_id_reponse in ('3664')
-- and coregistration_campagne_annonceur = 1651
-- and coregistration_eligible = 1
-- );
-- fin requete sous question

insert into coregistration.expandt_auto_non_eligible (expandt_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1651
and coregistration_champ = 16
and coregistration_eligible = 1
and coregistration_valeur not like '1';
-- on passe les lignes traitees a expandtable 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 = 1651
and coregistration_champ = 16
and coregistration_eligible = 1
and coregistration_valeur not like '1'
);