select a.wallet_id, a.id, a.carte_emettrice_id, a.carte_receptrice_id,
a.code_evenement,a.code_utilisateur_saisie,a.date_enregistrement_transaction,a.date_transaction,
a.ind_annulation,a.is_online,a.montant_transaction,a.motif,a.motif_annulation,a.numero_operation,
a.operation_offline_id,a.produit,a.ref_terminal,a.report_cumul_consommation_offline,
a.report_cumul_consommation_synchronise,a.report_plafond_offline,a.report_solde_online_on_card,
a.solde_apres_emmission,a.solde_apres_reception,a.solde_avant_emission,a.solde_avant_reception,
a.statut,a.uid_card,a.ticket_carburant_id,a.version_mobile,a.volume,
a.statut_remontee_annulation,a.statut_synchro_to_etab,
a.ind_espece,a.ind_trx_forcage_inter_oper,a.deleted+'0',
b.num_carte as numCarteEmetrice ,b.intitule as intituleCarteEmetrice,b.statut as 'statut_carte_emetrice',
c.num_carte as numCarteReceptrice ,c.intitule as intituleCarteReceptrice,c.statut as 'statut_carte_receptrice'
from (operation a left outer join carte b on a.carte_emettrice_id=b.id) left outer join carte c on a.carte_receptrice_id=c.id
where a.id not in (select b.operation_id from ecriture b) 
and a.date_transaction >= '2021-01-01'
order by a.date_transaction ;