select * from cotisations_commande where id = "8118" select * from cms_frontusers where identifiant = "p.bonnetete14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8118" select * from cotisations where identifiant = "p.bonnetete14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 073850 payment_means : VISA transmission_date : 20151026063850 payment_time : 074045 payment_date : 20151026 response_code : 00 payment_certificate : 670679a0f8e7 authorisation_id : 723233 currency_code : 978 card_number : 4970.84 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bonnetete14 order_id : 8118 customer_email : p.bonnetete14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8120" select * from cms_frontusers where identifiant = "m.testevuide16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8120" select * from cotisations where identifiant = "m.testevuide16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103750 payment_means : MASTERCARD transmission_date : 20151026093750 payment_time : 104051 payment_date : 20151026 response_code : 00 payment_certificate : 5e49f9a815dc authorisation_id : 532500 currency_code : 978 card_number : 5573.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.testevuide16 order_id : 8120 customer_email : m.testevuide16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201808 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8121" select * from cms_frontusers where identifiant = "l.robidou13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8121" select * from cotisations where identifiant = "l.robidou13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 105755 payment_means : VISA transmission_date : 20151026095755 payment_time : 105937 payment_date : 20151026 response_code : 00 payment_certificate : 59d7a995c9ee authorisation_id : 533636 currency_code : 978 card_number : 4970.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.robidou13 order_id : 8121 customer_email : l.robidou13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125311 payment_means : VISA transmission_date : 20151026115311 payment_time : 125544 payment_date : 20151026 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.gillardin21 order_id : 8122 customer_email : m.gillardin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8124" select * from cms_frontusers where identifiant = "s.colas03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8124" select * from cotisations where identifiant = "v.claudel07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163911 payment_means : MASTERCARD transmission_date : 20151026153911 payment_time : 164312 payment_date : 20151026 response_code : 00 payment_certificate : f40b3969a1fb authorisation_id : 607618 currency_code : 978 card_number : 5131.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.colas03 order_id : 8124 customer_email : s.colas03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8125" select * from cms_frontusers where identifiant = "b.vigreux06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8125" select * from cotisations where identifiant = "b.vigreux06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180501 payment_means : VISA transmission_date : 20151026170501 payment_time : 180842 payment_date : 20151026 response_code : 00 payment_certificate : 121bf1bab48a authorisation_id : 282351 currency_code : 978 card_number : 4973.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.vigreux06 order_id : 8125 customer_email : b.vigreux06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185645 payment_means : MASTERCARD transmission_date : 20151026175645 payment_time : 190003 payment_date : 20151026 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.reissier21 order_id : 8127 customer_email : p.reissier21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190350 payment_means : MASTERCARD transmission_date : 20151026180350 payment_time : 190646 payment_date : 20151026 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.reissier21 order_id : 8127 customer_email : p.reissier21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190753 payment_means : MASTERCARD transmission_date : 20151026180753 payment_time : 191218 payment_date : 20151026 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.reissier21 order_id : 8127 customer_email : p.reissier21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191651 payment_means : MASTERCARD transmission_date : 20151026181651 payment_time : 191826 payment_date : 20151026 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.blanchard02 order_id : 8128 customer_email : a.blanchard02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8128" select * from cms_frontusers where identifiant = "a.blanchard02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8128" select * from cotisations where identifiant = "a.blanchard02" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.blanchard02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191839 payment_means : MASTERCARD transmission_date : 20151026181839 payment_time : 192001 payment_date : 20151026 response_code : 00 payment_certificate : f8993d5bbbc9 authorisation_id : 923373 currency_code : 978 card_number : 5341.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.blanchard02 order_id : 8128 customer_email : a.blanchard02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8129" select * from cms_frontusers where identifiant = "x.peraleda30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8129" select * from cotisations where identifiant = "x.peraleda30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192500 payment_means : VISA transmission_date : 20151026182500 payment_time : 192934 payment_date : 20151026 response_code : 00 payment_certificate : d836e395e1c9 authorisation_id : 166727 currency_code : 978 card_number : 4978.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.peraleda30 order_id : 8129 customer_email : x.peraleda30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8132" select * from cms_frontusers where identifiant = "jp.biet19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8132" select * from cotisations where identifiant = "jp.biet19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200944 payment_means : MASTERCARD transmission_date : 20151026190944 payment_time : 201320 payment_date : 20151026 response_code : 00 payment_certificate : babfcce3d135 authorisation_id : 137292 currency_code : 978 card_number : 5137.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.biet19 order_id : 8132 customer_email : jp.biet19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8131" select * from cms_frontusers where identifiant = "a.bourges19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8131" select * from cotisations where identifiant = "a.bourges19" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200641 payment_means : VISA transmission_date : 20151026190641 payment_time : 201357 payment_date : 20151026 response_code : 00 payment_certificate : fb0104254d50 authorisation_id : 112026 currency_code : 978 card_number : 4970.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.bourges19 order_id : 8131 customer_email : a.bourges19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8133" select * from cms_frontusers where identifiant = "l.dodin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8133" select * from cotisations where identifiant = "l.dodin03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201546 payment_means : MASTERCARD transmission_date : 20151026191546 payment_time : 201726 payment_date : 20151026 response_code : 00 payment_certificate : a114fe721c42 authorisation_id : 630281 currency_code : 978 card_number : 5131.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.dodin03 order_id : 8133 customer_email : l.dodin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8134" select * from cms_frontusers where identifiant = "m.cao08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8134" select * from cotisations where identifiant = "m.cao08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202044 payment_means : VISA transmission_date : 20151026192044 payment_time : 202234 payment_date : 20151026 response_code : 00 payment_certificate : 3b51e6f589f5 authorisation_id : 225828 currency_code : 978 card_number : 4975.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.cao08 order_id : 8134 customer_email : m.cao08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8135" select * from cms_frontusers where identifiant = "v.joly28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8135" select * from cotisations where identifiant = "v.joly28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202939 payment_means : MASTERCARD transmission_date : 20151026192939 payment_time : 203111 payment_date : 20151026 response_code : 00 payment_certificate : c437a41d0d79 authorisation_id : 944263 currency_code : 978 card_number : 5341.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.joly28 order_id : 8135 customer_email : v.joly28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8137" select * from cms_frontusers where identifiant = "r.chamayou13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8137" select * from cotisations where identifiant = "r.chamayou13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203830 payment_means : VISA transmission_date : 20151026193830 payment_time : 204036 payment_date : 20151026 response_code : 00 payment_certificate : 3dae664ae36d authorisation_id : 843711 currency_code : 978 card_number : 4970.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.chamayou13 order_id : 8137 customer_email : r.chamayou13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8138" select * from cms_frontusers where identifiant = "p.barthes14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8138" select * from cotisations where identifiant = "p.barthes14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205227 payment_means : VISA transmission_date : 20151026195227 payment_time : 205410 payment_date : 20151026 response_code : 00 payment_certificate : ac9fdeb277ef authorisation_id : 929823 currency_code : 978 card_number : 4970.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.barthes14 order_id : 8138 customer_email : p.barthes14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8139" select * from cms_frontusers where identifiant = "g.gendre02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8139" select * from cotisations where identifiant = "g.gendre02" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "g.gendre02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205258 payment_means : MASTERCARD transmission_date : 20151026195258 payment_time : 205446 payment_date : 20151026 response_code : 00 payment_certificate : 47d81ee241ab authorisation_id : 415264 currency_code : 978 card_number : 5341.00 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.gendre02 order_id : 8139 customer_email : g.gendre02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8140" select * from cms_frontusers where identifiant = "l.charles08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8140" select * from cotisations where identifiant = "l.charles08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205824 payment_means : VISA transmission_date : 20151026195824 payment_time : 210438 payment_date : 20151026 response_code : 00 payment_certificate : 389ec1e5126d authorisation_id : 249931 currency_code : 978 card_number : 4974.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.charles08 order_id : 8140 customer_email : l.charles08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8142" select * from cms_frontusers where identifiant = "c.senan28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8142" select * from cotisations where identifiant = "c.senan28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220242 payment_means : MASTERCARD transmission_date : 20151026210242 payment_time : 220410 payment_date : 20151026 response_code : 00 payment_certificate : b77ab72f6466 authorisation_id : 191556 currency_code : 978 card_number : 5131.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.senan28 order_id : 8142 customer_email : c.senan28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------