-- requete sur email
insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
select coregistration_coregistration_affichage
from coregistration
where coregistration_campagne_annonceur = 1210
and coregistration_champ = 1
and coregistration_eligible = 1
and (
        coregistration_valeur like ('%Alfa%')
		or coregistration_valeur like ('%Audi%')
		or coregistration_valeur like ('%BMW%')
		or coregistration_valeur like ('%Chevrolet%')
		or coregistration_valeur like ('%Chrysler%')
		or coregistration_valeur like ('%Citroen%')
		or coregistration_valeur like ('%Dacia%')
		or coregistration_valeur like ('%DS%')
		or coregistration_valeur like ('%Fiat%')
		or coregistration_valeur like ('%Ford%')
		or coregistration_valeur like ('%Honda%')
		or coregistration_valeur like ('%Hyundai%')
		or coregistration_valeur like ('%Infiniti%')
		or coregistration_valeur like ('%Isuzu%')
		or coregistration_valeur like ('%Iveco%')
		or coregistration_valeur like ('%Jaguar%')
		or coregistration_valeur like ('%Jeep%')
		or coregistration_valeur like ('%Kia%')
		or coregistration_valeur like ('%Lancia%')
		or coregistration_valeur like ('%Land%')
		or coregistration_valeur like ('%Lexus%')
		or coregistration_valeur like ('%Mazda%')
		or coregistration_valeur like ('%Mercedes%')
		or coregistration_valeur like ('%MINI%')
		or coregistration_valeur like ('%Mitsubishi%')
		or coregistration_valeur like ('%Nissan%')
		or coregistration_valeur like ('%Opel%')
		or coregistration_valeur like ('%MG%')
		or coregistration_valeur like ('%Peugeot%')
		or coregistration_valeur like ('%Piaggio%')
		or coregistration_valeur like ('%Renault%')
		or coregistration_valeur like ('%Rover%')
		or coregistration_valeur like ('%Saab%')
		or coregistration_valeur like ('%SEAT%')
		or coregistration_valeur like ('%Skoda%')
		or coregistration_valeur like ('%smart%')
		or coregistration_valeur like ('%Subaru%')
		or coregistration_valeur like ('%Suzuki%')
		or coregistration_valeur like ('%Volkswagen%')
		or coregistration_valeur like ('%Toyota%')
		or coregistration_valeur like ('%Volvo%')
		or coregistration_valeur like ('%VW%')
		or coregistration_valeur like ('%GVF%')
		or coregistration_valeur like ('%RRG%')
		or coregistration_valeur like ('%PSA%')
		or coregistration_valeur like ('%FCA%')
		
        -- or coregistration_valeur like ('%@yopmail.%')
);
-- 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 = 1210
and coregistration_champ = 1
and coregistration_eligible = 1
and (
        coregistration_valeur like ('%Alfa%')
		or coregistration_valeur like ('%Audi%')
		or coregistration_valeur like ('%BMW%')
		or coregistration_valeur like ('%Chevrolet%')
		or coregistration_valeur like ('%Chrysler%')
		or coregistration_valeur like ('%Citroen%')
		or coregistration_valeur like ('%Dacia%')
		or coregistration_valeur like ('%DS%')
		or coregistration_valeur like ('%Fiat%')
		or coregistration_valeur like ('%Ford%')
		or coregistration_valeur like ('%Honda%')
		or coregistration_valeur like ('%Hyundai%')
		or coregistration_valeur like ('%Infiniti%')
		or coregistration_valeur like ('%Isuzu%')
		or coregistration_valeur like ('%Iveco%')
		or coregistration_valeur like ('%Jaguar%')
		or coregistration_valeur like ('%Jeep%')
		or coregistration_valeur like ('%Kia%')
		or coregistration_valeur like ('%Lancia%')
		or coregistration_valeur like ('%Land%')
		or coregistration_valeur like ('%Lexus%')
		or coregistration_valeur like ('%Mazda%')
		or coregistration_valeur like ('%Mercedes%')
		or coregistration_valeur like ('%MINI%')
		or coregistration_valeur like ('%Mitsubishi%')
		or coregistration_valeur like ('%Nissan%')
		or coregistration_valeur like ('%Opel%')
		or coregistration_valeur like ('%MG%')
		or coregistration_valeur like ('%Peugeot%')
		or coregistration_valeur like ('%Piaggio%')
		or coregistration_valeur like ('%Renault%')
		or coregistration_valeur like ('%Rover%')
		or coregistration_valeur like ('%Saab%')
		or coregistration_valeur like ('%SEAT%')
		or coregistration_valeur like ('%Skoda%')
		or coregistration_valeur like ('%smart%')
		or coregistration_valeur like ('%Subaru%')
		or coregistration_valeur like ('%Suzuki%')
		or coregistration_valeur like ('%Volkswagen%')
		or coregistration_valeur like ('%Toyota%')
		or coregistration_valeur like ('%Volvo%')
		or coregistration_valeur like ('%VW%')
		or coregistration_valeur like ('%GVF%')
		or coregistration_valeur like ('%RRG%')
		or coregistration_valeur like ('%PSA%')
		or coregistration_valeur like ('%FCA%')
)
);