-- requete sur mail
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select *
from coregistration 
where coregistration_campagne_annonceur = 998
and coregistration_champ = 1
and coregistration_eligible = 1
and lower(coregistration_valeur) similar to '%(alfa|audi|bmw|chevrolet|chrysler|citroen|dacia|ds|fiat|ford|honda|hyundai|infiniti|isuzu|iveco|jaguar|jeep|kia|lancia|land|lexus|mazda|mercedes|mg|mini|mitsubishi|nissan|opel|peugeot|piaggio|renault|rover|saab|seat|skoda|smart|subaru|suzuki|toyota|volkswagen|volvo|vw|gvf|rrg|psa|fca)%';
-- 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 = 998
and coregistration_champ = 1
and coregistration_eligible = 1
and lower(coregistration_valeur) similar to '%(alfa|audi|bmw|chevrolet|chrysler|citroen|dacia|ds|fiat|ford|honda|hyundai|infiniti|isuzu|iveco|jaguar|jeep|kia|lancia|land|lexus|mazda|mercedes|mg|mini|mitsubishi|nissan|opel|peugeot|piaggio|renault|rover|saab|seat|skoda|smart|subaru|suzuki|toyota|volkswagen|volvo|vw|gvf|rrg|psa|fca)%'
);
-- fin requete mail