-- requete sur ip
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 153
and coregistration_champ = 13
and coregistration_eligible = 1
and (select name from general.geoip_country(general.cast_to_inet(coregistration_valeur))) != 'France';
-- 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 = 153
and coregistration_champ = 13
and coregistration_eligible = 1
and (select name from general.geoip_country(general.cast_to_inet(coregistration_valeur))) != 'France'
);
-- fin requete ip

-- 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 = 153
and coregistration_champ = 6
and coregistration_eligible = 1
and substring(coregistration_valeur from 1 for 2) not in
('01','02','12','13','17','18','21','25','27','29','30','31','33','38','42','44','45','51','56','59','60','61','62','63','67','68','69','72','25','77','78','80','83','85','86','91','93','94','92','20','95','75');
-- 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 = 153
and coregistration_champ = 6
and coregistration_eligible = 1
and substring(coregistration_valeur from 1 for 2) not in
('01','02','12','13','17','18','21','25','27','29','30','31','33','38','42','44','45','51','56','59','60','61','62','63','67','68','69','72','25','77','78','80','83','85','86','91','93','94','92','20','95','75')
);
-- fin requete ip