with profils as (
	select coregistration_coregistration_affichage
	from coregistration.campagne_annonceur
	inner join general.annonceur on annonceur_id = campagne_annonceur_annonceur
	inner join coregistration.champ_campagne on champ_campagne_campagne_annonceur = campagne_annonceur_id
	left join coregistration.coregistration on champ_campagne_campagne_annonceur = coregistration_campagne_annonceur and coregistration_champ = champ_campagne_champ
	where 1=1
	and coregistration_eligible = -2
	and (
		coregistration_valeur is null
		or coregistration_valeur = ''
	)
	and coregistration_coregistration_affichage = 15467
	group by coregistration_coregistration_affichage
),
insertion as (
	insert into coregistration.export_auto_non_eligible (export_auto_non_eligible_affichage)
	select coregistration_coregistration_affichage
	from profils
)
update coregistration.coregistration
set coregistration_eligible = 2
where coregistration_coregistration_affichage in (
	select coregistration_coregistration_affichage
	from profils
)