Analyse PNR de leads

select 
    r.emp_naissance as "Date de naissance",
    rc.singulier_court as "Civilité",
    IF(r.emp_id_statut_pro = 20, 'Oui', 'Non') as "Retraité",
    r.tel_dom as "Téléphone fixe",
    r.tel_port as "Téléphone portable",
    IF(r.id_situ_immo = 1, 'Propriétaire', 'Locataire') as "Situation",
    r.nb_credits_conso as "Nb crédits conso",
    r.perso_restant as "Montant total restant du conso",
    r.immo_restant as "Montant total restant du immo",
    r.immo_mens as "Montant mensualités immobilieres",
    r.loyer as "Loyer",
    r.emp_revenus + r.co_revenus as "Revenus",
    IF(r.co_nom = '', 'Non', 'Oui')  as "Coemprunteur",
    r.tresorerie_souhaitee  as "Trésorerie",
    -- colonnes supplémentaires
    r.email,
    pa.xtor_origin 
from rouaix r
    inner join ref_civilite rc on rc.id_civilite = r.emp_id_civilite 
    left join piste_audit pa on pa.form_id_boi = r.id 
where 
    pa.id_connecteur in (10,11) -- IM & CF
    and pa.profil is not null -- intercos tentées
    and r.`date` >= '2020-09-05'
    and r.`date` < '2020-10-25'
order by 
    r.id desc
;