SELECT
id,
pa_created_dt,
xtor_origin,
"Libelle campagne" as campaign,
"PAR-XXX-XX" as "xtor", -- XTOR
"5666" as part, -- PRT_ID
"209" as agency, -- AG_ID
"1" as agent, -- REQ_DOSSIER_OWNER (USR_ID)
"1" as cmo, -- REQ_CMO (USR_ID)
email,
form_id_boi,
form_data,
"Lead reçu le {{ date }} sur la campagne {{ xtor_origin }} ({{ campaign }})"
as comment -- REQ_COMMENT (new entry)
FROM piste_audit
WHERE 1=1
AND type = 'Reception'
AND -- your conditions here