-- 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 = 235
and coregistration_champ = 12
and coregistration_eligible = 1
and EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 18;
-- on passe les lignes traités à 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 = 235
and coregistration_champ = 12
and coregistration_eligible = 1
and EXTRACT(YEAR FROM age(now()::date, general.cast_to_date(coregistration_valeur))) < 18
);
-- 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 = 235
and coregistration_champ = 6
and coregistration_eligible = 1
and (substring(coregistration_valeur from 1 for 2) not in ('02','03', '04', '18', '19', '20')
-- and coregistration_valeur not in ('75001', '92200', '92300')
and coregistration_valeur not in (
		'75001', '75002', '75003', '75004', '75005', '75006', '75007', '75008', '75009', '75010', '75011', '75012', '75013', '75014', '75015', '75016', '75017', '75018', '75019', '75020', '92100', '92130', '92200', '92300'
	)
);


-- on passe les lignes traités à 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 = 235
and coregistration_champ = 6
and coregistration_eligible = 1
and (substring(coregistration_valeur from 1 for 2) not in ('02','03', '04', '18', '19', '20')
and coregistration_valeur not in ('75001', '92200', '92300'))
);
-- fin requete cp