SET application_name = 'suivi_rentabilite : sponso stats';

select
	srt.source as source,
        ca.campagne_annonceur_nom as "campagne",
        count(distinct p.profil_id) AS "annonceur",
        p.profil_remuneration * count(distinct p.profil_id) as "remuneration"
from sponsoring.profil as p
inner join sponsoring.campagne_annonceur as ca on ca.campagne_annonceur_id = p.profil_campagne
inner join suivi_rentabilite_travail as srt on srt.email = p.profil_email
-- inner join general.suivi_rentabilite_travail_source as srts on srts.source = srt.source
where p.profil_site = 26
and p.profil_date >= '2024-01-01'
and p.profil_date < '2024-02-01'
and p.profil_etat = 1
and p.profil_eligible = 1

group by srt.source, campagne_annonceur_nom, profil_remuneration