with clics_fraudes as (
	-- tous les clics problematiques car cookie flnetwork_id vide
	select clic_id -- clic_data_user_agent, clic_data_internaute, clic_data_extra
	from affiliation.clic_data
	inner join affiliation.clic on clic_data_clic = clic_id
	where  clic_data_internaute is null
	and clic_valide = 1
	and clic_date_epoch >= :periode_debut
	and clic_date_epoch < :periode_fin
	and clic_date_epoch >= 1448924400

	INTERSECT

	-- tous les clics potentiellement problematiques HTTP_ACCEPT */ *
	select clic_id -- clic_data_user_agent, clic_data_internaute, clic_data_extra
	from affiliation.clic_data
	inner join affiliation.clic on clic_data_clic = clic_id
	where clic_data_extra->'_server'->>'HTTP_ACCEPT' = '*/*'
	and clic_valide = 1
	and clic_date_epoch >= :periode_debut
	and clic_date_epoch < :periode_fin
	and clic_date_epoch >= 1448924400
)
update affiliation.clic
set clic_valide = 0
from clics_fraudes
where clic.clic_id = clics_fraudes.clic_id