-- 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 = 384
and coregistration_champ = 12
and coregistration_eligible = 1
and EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 30;
-- 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 = 384
and coregistration_champ = 12
and coregistration_eligible = 1
and EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 30
);
-- 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 = 384
and coregistration_champ = 6
and coregistration_eligible = 1
and substring(coregistration_valeur from 1 for 2) not in ('01','10','12','16','17','27','30','33','34','39','45','46','54','55','57','58','67','68','69','76','78','82','84','89','91','92','93');
-- 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 = 384
and coregistration_champ = 6
and coregistration_eligible = 1
and substring(coregistration_valeur from 1 for 2) not in ('01','10','12','16','17','27','30','33','34','39','45','46','54','55','57','58','67','68','69','76','78','82','84','89','91','92','93')
);
-- fin requete cp