-- insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
-- select coregistration_coregistration_affichage
-- from coregistration
-- where coregistration_campagne_annonceur = 1300
-- and coregistration_champ = 6
-- and coregistration_eligible = 1
-- and (
        -- LEFT(coregistration_valeur, 2) not in 
		-- (
		-- 01,02,03,05,08,10,14,15,19,21,23,25,27,28,38,39,42,43,45,51,52,54,55,57,58,59,60,61,62,63,67,68,69,70,71,73,74,75,76,77,78,80,87,88,89,90,91,92,93,94,95
		-- )
-- );
-- 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 = 1242
-- and coregistration_champ = 6
-- and coregistration_eligible = 1
-- and (
        -- LEFT(coregistration_valeur, 2) not in 
		-- (
		-- 01,02,03,05,08,10,14,15,19,21,23,25,27,28,38,39,42,43,45,51,52,54,55,57,58,59,60,61,62,63,67,68,69,70,71,73,74,75,76,77,78,80,87,88,89,90,91,92,93,94,95
		-- )
-- );