-- requete sur date naissance
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage 
from coregistration 
where coregistration_campagne_annonceur = 402
and coregistration_champ = 12
and coregistration_eligible = 1
and (
	EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 30
	or EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) > 45
);
-- 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 = 402
and coregistration_champ = 12
and coregistration_eligible = 1
and (
	EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 30
	or EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) > 45
));
-- fin requete date naissance

-- requete sur cp
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 402
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('65100','01190','01270','01560','02120','02140','02150','02170','02190','02250','02260','02340','02360','02500','02550','02580','02620','02830','03250','07310','07320','07690','08130','08190','08220','08260','08270','08290','08300','08310','08360','08380','08400','08430','08460','11100','11110','11160','11310','11380','11390','11560','11590','11600','15100','15190','15200','15210','15240','15270','15350','15380','15400','15500','16100','16130','16220','16300','16310','16320','16370','16380','17100','17120','17150','17240','17260','17460','17500','17520','17600','17610','17770','17800','17810','19110','19160','19200','24170','24200','24220','24250','24300','24310','24320','24340','24360','24370','24450','24460','24470','24530','24550','24590','24800','25113','25150','25200','25230','25240','25250','25260','25270','25310','25340','25350','25400','25420','25460','25490','25550','25560','25600','25630','25700','25750','29100','29150','29160','29200','29217','29280','29290','29300','29310','29360','29460','29470','29480','29490','29550','29560','29570','29590','29770','29790','29800','29810','29820','29850','30111','30121','30220','30240','30250','30260','30470','30660','30670','32340','32480','32700','33113','33124','33125','33130','33140','33190','33210','33270','33360','33370','33410','33420','33430','33490','33540','33550','33640','33650','33670','33720','33730','33750','33760','33850','33880','34110','34120','34130','34140','34150','34160','34170','34200','34210','34220','34230','34250','34270','34280','34290','34300','34310','34320','34330','34340','34350','34370','34380','34400','34410','34420','34430','34440','34450','34470','34480','34490','34500','34510','34530','34540','34550','34560','34570','34590','34620','34630','34660','34670','34680','34690','34710','34730','34740','34750','34760','34770','34790','34810','34820','34830','34850','34880','34920','34970','34980','34990','37140','37420','37500','39110','39130','39140','39150','39160','39190','39210','39230','39250','39270','39300','39320','39400','39460','39520','39570','39600','39800','40100','40140','40180','40230','40250','40260','40290','40300','40330','40350','40360','40370','40380','40390','40400','40465','40990','42114','42120','42122','42123','42153','42155','42190','42260','42300','42310','42370','42430','42460','42470','42510','42540','42590','42630','42640','42670','42720','42750','42820','42830','42840','43000','43100','43120','43130','43140','43150','43160','43190','43200','43210','43220','43230','43250','43260','43270','43290','43300','43330','43350','43360','43380','43390','43400','43410','43430','43440','43450','43500','43520','43550','43590','43600','43620','43700','43750','43770','43800','44117','44160','44210','44250','44260','44320','44350','44360','44380','44410','44480','44500','44510','44550','44560','44570','44600','44640','44680','44720','44730','44740','44750','44760','44770','46090','46150','46200','46240','46250','46300','46310','46340','46350','46360','46500','46600','47000','47110','47130','47140','47220','47240','47270','47300','47310','47340','47360','47390','47450','47470','47480','47510','47520','47550','47600','49160','49250','49260','49310','49320','49350','49390','49400','49540','49560','49590','49650','49680','49700','49730','51110','51250','51330','51340','51490','52100','52170','52410','53110','53140','53250','53640','53700','54111','54150','54240','54290','54310','54490','54560','54580','54640','54660','54680','54750','54780','54790','54800','54910','54980','55000','55130','55170','55190','55200','55220','55250','55260','55290','55300','55310','55500','55800','56100','56150','56240','56260','56270','56290','56310','56320','56330','56400','56410','56440','56520','56530','56540','56550','56570','56590','56600','56620','56650','56670','56680','56690','56700','56850','57050','57070','57100','57120','57130','57140','57150','57160','57175','57180','57190','57220','57240','57245','57250','57270','57280','57290','57300','57310','57320','57330','57340','57360','57365','57370','57380','57400','57420','57440','57470','57480','57490','57500','57525','57530','57550','57560','57570','57580','57640','57650','57660','57680','57690','57700','57710','57730','57740','57780','57800','57820','57840','57850','57860','57870','57880','57890','57920','57930','57940','57960','59132','59177','59186','59212','59219','59440','59610','59740','60000','60100','60110','60119','60130','60134','60140','60155','60160','60173','60175','60180','60190','60230','60240','60250','60260','60270','60290','60300','60340','60370','60390','60420','60430','60460','60480','60500','60510','60530','60540','60550','60570','60580','60600','60660','60680','60700','60710','60730','60740','60790','60810','60820','60870','60930','60940','61100','61140','61150','61200','61210','61220','61320','61330','61410','61420','61440','61450','61490','61570','61600','61700','63113','63220','63340','63420','63570','63580','63630','63680','63690','63750','63810','63850','64260','64270','64300','64420','64460','64510','64520','64530','64800','65000','65100','65110','65120','65130','65190','65200','65260','65270','65290','65310','65320','65350','65360','65380','65400','65420','65430','65460','65490','65560','65600','65690','65710','65800','67117','67120','67170','67190','67270','67280','67290','67310','67320','67330','67340','67350','67370','67430','67440','67490','67520','67670','67700','67710','67790','67990','68118','68128','68130','68170','68210','68220','68330','68350','68400','68440','68480','68490','68510','68560','68580','68640','68680','68720','68730','68870','68960','69240','69470','69550','70000','70110','70160','70170','70200','70210','70220','70240','70250','70270','70280','70290','70300','70310','70320','70400','70440','70800','71110','71170','71240','71290','71310','71330','71340','71370','71440','71470','71480','71500','71580','71620','71700','71740','79100','79290','81090','81100','81110','81120','81140','81150','81200','81210','81220','81240','81260','81270','81290','81300','81310','81330','81360','81370','81390','81440','81470','81490','81500','81570','81580','81600','81660','81700','81710','81800','81990','82120','82150','82190','82200','82340','82360','82400','86120','87150','87230','87440','88000','88120','88130','88150','88190','88200','88220','88240','88260','88270','88330','88340','88360','88370','88380','88390','88440','88450','88460','88500','88510','88550','88600','88640','88700','90000','90100','90110','90120','90130','90140','90150','90160','90170','90200','90300','90330','90340','90350','90360','90380','90400','90500','90600','90700','90800','90850','95260','95270','95340','95590','95660','95690','95810','95820','34000','34070','34080','34090','42132','43530','43810','44580','56830','57000','57110','57111','57113','57114','57116','57117','57118','57119','57124','57134','57144','57155','57157','57158','57159','57176','57185','57210','57255','57385','57405','57444','57445','57535','57565','57635','57645','57655','57685','57855','57865','57925','57935','57950','57970','60149','60650','60840','68100','68200','68300','81000');
-- 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 = 402
and coregistration_champ = 6
and coregistration_eligible = 1
and coregistration_valeur not in ('65100','01190','01270','01560','02120','02140','02150','02170','02190','02250','02260','02340','02360','02500','02550','02580','02620','02830','03250','07310','07320','07690','08130','08190','08220','08260','08270','08290','08300','08310','08360','08380','08400','08430','08460','11100','11110','11160','11310','11380','11390','11560','11590','11600','15100','15190','15200','15210','15240','15270','15350','15380','15400','15500','16100','16130','16220','16300','16310','16320','16370','16380','17100','17120','17150','17240','17260','17460','17500','17520','17600','17610','17770','17800','17810','19110','19160','19200','24170','24200','24220','24250','24300','24310','24320','24340','24360','24370','24450','24460','24470','24530','24550','24590','24800','25113','25150','25200','25230','25240','25250','25260','25270','25310','25340','25350','25400','25420','25460','25490','25550','25560','25600','25630','25700','25750','29100','29150','29160','29200','29217','29280','29290','29300','29310','29360','29460','29470','29480','29490','29550','29560','29570','29590','29770','29790','29800','29810','29820','29850','30111','30121','30220','30240','30250','30260','30470','30660','30670','32340','32480','32700','33113','33124','33125','33130','33140','33190','33210','33270','33360','33370','33410','33420','33430','33490','33540','33550','33640','33650','33670','33720','33730','33750','33760','33850','33880','34110','34120','34130','34140','34150','34160','34170','34200','34210','34220','34230','34250','34270','34280','34290','34300','34310','34320','34330','34340','34350','34370','34380','34400','34410','34420','34430','34440','34450','34470','34480','34490','34500','34510','34530','34540','34550','34560','34570','34590','34620','34630','34660','34670','34680','34690','34710','34730','34740','34750','34760','34770','34790','34810','34820','34830','34850','34880','34920','34970','34980','34990','37140','37420','37500','39110','39130','39140','39150','39160','39190','39210','39230','39250','39270','39300','39320','39400','39460','39520','39570','39600','39800','40100','40140','40180','40230','40250','40260','40290','40300','40330','40350','40360','40370','40380','40390','40400','40465','40990','42114','42120','42122','42123','42153','42155','42190','42260','42300','42310','42370','42430','42460','42470','42510','42540','42590','42630','42640','42670','42720','42750','42820','42830','42840','43000','43100','43120','43130','43140','43150','43160','43190','43200','43210','43220','43230','43250','43260','43270','43290','43300','43330','43350','43360','43380','43390','43400','43410','43430','43440','43450','43500','43520','43550','43590','43600','43620','43700','43750','43770','43800','44117','44160','44210','44250','44260','44320','44350','44360','44380','44410','44480','44500','44510','44550','44560','44570','44600','44640','44680','44720','44730','44740','44750','44760','44770','46090','46150','46200','46240','46250','46300','46310','46340','46350','46360','46500','46600','47000','47110','47130','47140','47220','47240','47270','47300','47310','47340','47360','47390','47450','47470','47480','47510','47520','47550','47600','49160','49250','49260','49310','49320','49350','49390','49400','49540','49560','49590','49650','49680','49700','49730','51110','51250','51330','51340','51490','52100','52170','52410','53110','53140','53250','53640','53700','54111','54150','54240','54290','54310','54490','54560','54580','54640','54660','54680','54750','54780','54790','54800','54910','54980','55000','55130','55170','55190','55200','55220','55250','55260','55290','55300','55310','55500','55800','56100','56150','56240','56260','56270','56290','56310','56320','56330','56400','56410','56440','56520','56530','56540','56550','56570','56590','56600','56620','56650','56670','56680','56690','56700','56850','57050','57070','57100','57120','57130','57140','57150','57160','57175','57180','57190','57220','57240','57245','57250','57270','57280','57290','57300','57310','57320','57330','57340','57360','57365','57370','57380','57400','57420','57440','57470','57480','57490','57500','57525','57530','57550','57560','57570','57580','57640','57650','57660','57680','57690','57700','57710','57730','57740','57780','57800','57820','57840','57850','57860','57870','57880','57890','57920','57930','57940','57960','59132','59177','59186','59212','59219','59440','59610','59740','60000','60100','60110','60119','60130','60134','60140','60155','60160','60173','60175','60180','60190','60230','60240','60250','60260','60270','60290','60300','60340','60370','60390','60420','60430','60460','60480','60500','60510','60530','60540','60550','60570','60580','60600','60660','60680','60700','60710','60730','60740','60790','60810','60820','60870','60930','60940','61100','61140','61150','61200','61210','61220','61320','61330','61410','61420','61440','61450','61490','61570','61600','61700','63113','63220','63340','63420','63570','63580','63630','63680','63690','63750','63810','63850','64260','64270','64300','64420','64460','64510','64520','64530','64800','65000','65100','65110','65120','65130','65190','65200','65260','65270','65290','65310','65320','65350','65360','65380','65400','65420','65430','65460','65490','65560','65600','65690','65710','65800','67117','67120','67170','67190','67270','67280','67290','67310','67320','67330','67340','67350','67370','67430','67440','67490','67520','67670','67700','67710','67790','67990','68118','68128','68130','68170','68210','68220','68330','68350','68400','68440','68480','68490','68510','68560','68580','68640','68680','68720','68730','68870','68960','69240','69470','69550','70000','70110','70160','70170','70200','70210','70220','70240','70250','70270','70280','70290','70300','70310','70320','70400','70440','70800','71110','71170','71240','71290','71310','71330','71340','71370','71440','71470','71480','71500','71580','71620','71700','71740','79100','79290','81090','81100','81110','81120','81140','81150','81200','81210','81220','81240','81260','81270','81290','81300','81310','81330','81360','81370','81390','81440','81470','81490','81500','81570','81580','81600','81660','81700','81710','81800','81990','82120','82150','82190','82200','82340','82360','82400','86120','87150','87230','87440','88000','88120','88130','88150','88190','88200','88220','88240','88260','88270','88330','88340','88360','88370','88380','88390','88440','88450','88460','88500','88510','88550','88600','88640','88700','90000','90100','90110','90120','90130','90140','90150','90160','90170','90200','90300','90330','90340','90350','90360','90380','90400','90500','90600','90700','90800','90850','95260','95270','95340','95590','95660','95690','95810','95820','34000','34070','34080','34090','42132','43530','43810','44580','56830','57000','57110','57111','57113','57114','57116','57117','57118','57119','57124','57134','57144','57155','57157','57158','57159','57176','57185','57210','57255','57385','57405','57444','57445','57535','57565','57635','57645','57655','57685','57855','57865','57925','57935','57950','57970','60149','60650','60840','68100','68200','68300','81000')
);
-- fin requete cp