insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1242
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur in (
		01390,01390,01390,01390,01390,01480,01480,01480,01600,02140,02200,02200,02200,02200,02200,02200,02200,02200,02200,02220,02290,02500,02500,06510,09120,09120,09270,09700,09700,10140,11500,28110,28120,28190,28190,28210,28260,28300,28300,28300,28300,28300,28300,28300,28300,28310,28360,28410,28410,28410,28410,28410,28410,28410,28410,28600,28630,28630,28630,28630,28630,28630,28630,28630,28630,28630,28630,28700,31220,31220,31800,33690,34080,34150,34160,34190,34230,34270,34270,34270,34370,34570,34570,34570,34730,34790,34800,34980,34980,34980,39110,45170,45170,45300,45300,45300,45300,45390,45480,45480,45480,45480,49120,49150,54650,57000,57050,57050,57050,57050,57050,57070,57070,57070,57070,57120,57120,57130,57130,57130,57130,57130,57130,57140,57140,57140,57140,57150,57155,57160,57160,57160,57160,57160,57175,57185,57230,57245,57245,57245,57245,57250,57255,57270,57280,57280,57300,57300,57300,57350,57360,57365,57365,57365,57380,57385,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57470,57525,57530,57530,57530,57530,57530,57530,57530,57530,57535,57640,57640,57640,57640,57640,57645,57645,57645,57645,57680,57680,57685,57690,57690,57855,57860,57950,59120,59141,59141,59157,59157,59161,59161,59161,59430,59430,60117,60126,60126,60130,60130,60138,60140,60140,60150,60150,60150,60150,60150,60150,60150,60150,60153,60160,60170,60170,60190,60190,60190,60190,60190,60190,60190,60190,60190,60280,60280,60310,60310,60310,60310,60320,60320,60320,60320,60400,60400,60400,60410,60420,60420,60420,60420,60490,60490,60490,60600,60610,60640,60680,60680,60680,60700,60700,60700,60700,60700,60710,60710,60750,60840,60840,60840,60870,60880,60880,60880,60940,60940,60940,67110,67110,67110,67110,67150,67160,67170,67220,67240,67240,67240,67240,67240,67250,67250,67260,67270,67270,67330,67340,67350,67350,67350,67350,67350,67360,67360,67360,67360,67440,67470,67470,67470,67480,67480,67480,67490,67500,67580,67590,67590,67620,67630,67630,67660,67700,67700,67700,67700,67770,67770,67790,67930,68220,68220,68320,68600,68600,68600,68600,68600,68600,68740,68740,68740,68920,69240,69240,70000,70000,73130,73130,73130,73130,73300,73300,73790,74310,74330,74330,74370,74370,76500,78550,78550,78550,78550,78790,78910,78910,78930,78930,79000,79000,79100,79100,79100,79140,79170,79180,79200,79200,79200,79230,79230,79250,79260,79300,79370,79370,79400,79400,79400,79400,79410,79410,79410,79460,79500,79500,79700,79700,80110,80110,80110,80170,80170,80500,80500,80500,80500,80500,80500,80500,86100,86220,86240,86440,86500,86530,86530,86540,86580,86580,91490,91490,91490,91510,91510,91580,91590,91590,91590,91590,91590,91720,91730,91730,91820,91820,91840,91850,95430,95430,95690,95760,95760
		)
		
        -- or coregistration_valeur like ('%@yopmail.%')
);
-- on passe les lignes traitees a exportable 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 = 1242
and coregistration_champ = 6
and coregistration_eligible = 1
and (
        coregistration_valeur in (
		01390,01390,01390,01390,01390,01480,01480,01480,01600,02140,02200,02200,02200,02200,02200,02200,02200,02200,02200,02220,02290,02500,02500,06510,09120,09120,09270,09700,09700,10140,11500,28110,28120,28190,28190,28210,28260,28300,28300,28300,28300,28300,28300,28300,28300,28310,28360,28410,28410,28410,28410,28410,28410,28410,28410,28600,28630,28630,28630,28630,28630,28630,28630,28630,28630,28630,28630,28700,31220,31220,31800,33690,34080,34150,34160,34190,34230,34270,34270,34270,34370,34570,34570,34570,34730,34790,34800,34980,34980,34980,39110,45170,45170,45300,45300,45300,45300,45390,45480,45480,45480,45480,49120,49150,54650,57000,57050,57050,57050,57050,57050,57070,57070,57070,57070,57120,57120,57130,57130,57130,57130,57130,57130,57140,57140,57140,57140,57150,57155,57160,57160,57160,57160,57160,57175,57185,57230,57245,57245,57245,57245,57250,57255,57270,57280,57280,57300,57300,57300,57350,57360,57365,57365,57365,57380,57385,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57420,57470,57525,57530,57530,57530,57530,57530,57530,57530,57530,57535,57640,57640,57640,57640,57640,57645,57645,57645,57645,57680,57680,57685,57690,57690,57855,57860,57950,59120,59141,59141,59157,59157,59161,59161,59161,59430,59430,60117,60126,60126,60130,60130,60138,60140,60140,60150,60150,60150,60150,60150,60150,60150,60150,60153,60160,60170,60170,60190,60190,60190,60190,60190,60190,60190,60190,60190,60280,60280,60310,60310,60310,60310,60320,60320,60320,60320,60400,60400,60400,60410,60420,60420,60420,60420,60490,60490,60490,60600,60610,60640,60680,60680,60680,60700,60700,60700,60700,60700,60710,60710,60750,60840,60840,60840,60870,60880,60880,60880,60940,60940,60940,67110,67110,67110,67110,67150,67160,67170,67220,67240,67240,67240,67240,67240,67250,67250,67260,67270,67270,67330,67340,67350,67350,67350,67350,67350,67360,67360,67360,67360,67440,67470,67470,67470,67480,67480,67480,67490,67500,67580,67590,67590,67620,67630,67630,67660,67700,67700,67700,67700,67770,67770,67790,67930,68220,68220,68320,68600,68600,68600,68600,68600,68600,68740,68740,68740,68920,69240,69240,70000,70000,73130,73130,73130,73130,73300,73300,73790,74310,74330,74330,74370,74370,76500,78550,78550,78550,78550,78790,78910,78910,78930,78930,79000,79000,79100,79100,79100,79140,79170,79180,79200,79200,79200,79230,79230,79250,79260,79300,79370,79370,79400,79400,79400,79400,79410,79410,79410,79460,79500,79500,79700,79700,80110,80110,80110,80170,80170,80500,80500,80500,80500,80500,80500,80500,86100,86220,86240,86440,86500,86530,86530,86540,86580,86580,91490,91490,91490,91510,91510,91580,91590,91590,91590,91590,91590,91720,91730,91730,91820,91820,91840,91850,95430,95430,95690,95760,95760
		)
		
        -- or coregistration_valeur like ('%@yopmail.%')
);


insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration.coregistration
where coregistration_campagne_annonceur = 1242
and coregistration_champ = 9
and coregistration_eligible = 0
and (
        coregistration_valeur not like ('06%,07%')
		
		
		
        -- or coregistration_valeur like ('%@yopmail.%')
);
-- on passe les lignes traitees a exportable 3 pour ne plus les selectionner
update coregistration.coregistration set coregistration_eligible = 3
where coregistration_coregistration_affichage in
(
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 1242
and coregistration_champ = 9
and coregistration_eligible = 0
and (
        coregistration_valeur not like ('06%,07%')