-- insert into coregistration.expandt_auto_non_eligible (expandt_auto_non_eligible_affichage)
-- select coregistration_coregistration_affichage
-- from coregistration.coregistration
-- where coregistration_campagne_annonceur = 1653
-- 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 = 1653
-- and coregistration_champ = 16
-- and coregistration_eligible = 1
-- and coregistration_valeur not like '1'
-- );