select * from cotisations_commande where id = "16563" select * from cms_frontusers where identifiant = "d.bourgoin25" 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 = "16563" select * from cotisations where identifiant = "d.bourgoin25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 055704 payment_means : MASTERCARD transmission_date : 20161123045704 payment_time : 055938 payment_date : 20161123 response_code : 00 payment_certificate : 7a5d277b50ea authorisation_id : 314455 currency_code : 978 card_number : 5135.07 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 : d.bourgoin25 order_id : 16563 customer_email : d.bourgoin25@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 082237 payment_means : VISA transmission_date : 20161123072237 payment_time : 082407 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.gaudin30 order_id : 16565 customer_email : m.gaudin30@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16564" select * from cms_frontusers where identifiant = "jl.bellanca23" 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 = "16564" select * from cotisations where identifiant = "jl.bellanca23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082204 payment_means : MASTERCARD transmission_date : 20161123072204 payment_time : 082423 payment_date : 20161123 response_code : 00 payment_certificate : 65119f2a3fcc authorisation_id : 051961 currency_code : 978 card_number : 5137.13 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 : jl.bellanca23 order_id : 16564 customer_email : jl.bellanca23@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 = "16566" select * from cms_frontusers where identifiant = "p.audebert22" 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 = "16566" select * from cotisations where identifiant = "p.audebert22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085344 payment_means : VISA transmission_date : 20161123075344 payment_time : 085621 payment_date : 20161123 response_code : 00 payment_certificate : 55d090f8fe05 authorisation_id : 451455 currency_code : 978 card_number : 4975.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.audebert22 order_id : 16566 customer_email : p.audebert22@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16567" select * from cms_frontusers where identifiant = "t1.andrieu01" 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 = "16567" select * from cotisations where identifiant = "t1.andrieu01" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t1.andrieu01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085716 payment_means : VISA transmission_date : 20161123075716 payment_time : 085846 payment_date : 20161123 response_code : 00 payment_certificate : bcf6f684b3c8 authorisation_id : 142844 currency_code : 978 card_number : 4975.22 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 : t1.andrieu01 order_id : 16567 customer_email : t1.andrieu01@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16568" select * from cms_frontusers where identifiant = "t.chouteau21" 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 = "16568" select * from cotisations where identifiant = "t.chouteau21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085840 payment_means : VISA transmission_date : 20161123075840 payment_time : 090023 payment_date : 20161123 response_code : 00 payment_certificate : 3bcd670791cc authorisation_id : 091425 currency_code : 978 card_number : 4533.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 : t.chouteau21 order_id : 16568 customer_email : t.chouteau21@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16569" select * from cms_frontusers where identifiant = "n.digaire24" 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 = "16569" select * from cotisations where identifiant = "n.digaire24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092119 payment_means : MASTERCARD transmission_date : 20161123082119 payment_time : 092216 payment_date : 20161123 response_code : 00 payment_certificate : 6a8ff589aeaa authorisation_id : 370542 currency_code : 978 card_number : 5137.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 : n.digaire24 order_id : 16569 customer_email : n.digaire24@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 = "16573" select * from cms_frontusers where identifiant = "p.venien26" 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 = "16573" select * from cotisations where identifiant = "p.venien26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101816 payment_means : VISA transmission_date : 20161123091816 payment_time : 102125 payment_date : 20161123 response_code : 00 payment_certificate : a9b280a90ae4 authorisation_id : 847435 currency_code : 978 card_number : 4970.36 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.venien26 order_id : 16573 customer_email : p.venien26@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 : 201704 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 : 4000 transaction_id : 104410 payment_means : MASTERCARD transmission_date : 20161123094410 payment_time : 105110 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5136.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.capelli20 order_id : 16574 customer_email : t.capelli20@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16576" select * from cms_frontusers where identifiant = "b.savarre15" 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 = "16576" select * from cotisations where identifiant = "b.savarre15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111414 payment_means : VISA transmission_date : 20161123101414 payment_time : 111600 payment_date : 20161123 response_code : 00 payment_certificate : ffd577181d42 authorisation_id : 167634 currency_code : 978 card_number : 4974.59 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.savarre15 order_id : 16576 customer_email : b.savarre15@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16577" select * from cms_frontusers where identifiant = "l.uroz04" 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 = "16577" select * from cotisations where identifiant = "l.uroz04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114136 payment_means : VISA transmission_date : 20161123104136 payment_time : 114359 payment_date : 20161123 response_code : 00 payment_certificate : b1495cea7033 authorisation_id : 721641 currency_code : 978 card_number : 4978.09 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.uroz04 order_id : 16577 customer_email : l.uroz04@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16578" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "16578" select * from cotisations where identifiant = "d.pacreau15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122731 payment_means : VISA transmission_date : 20161123112731 payment_time : 122913 payment_date : 20161123 response_code : 00 payment_certificate : d60ce9cae441 authorisation_id : 461843 currency_code : 978 card_number : 4970.11 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 : f.bureau27 order_id : 16578 customer_email : f.bureau27@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16579" select * from cms_frontusers where identifiant = "f.bureau27" 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 = "16579" select * from cotisations where identifiant = "e.bouclet29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123147 payment_means : VISA transmission_date : 20161123113147 payment_time : 123317 payment_date : 20161123 response_code : 00 payment_certificate : 04ed72130de6 authorisation_id : 432456 currency_code : 978 card_number : 4970.11 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 : f.bureau27 order_id : 16579 customer_email : f.bureau27@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16580" select * from cms_frontusers where identifiant = "d.bertrand10" 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 = "16580" select * from cotisations where identifiant = "c.welsch26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130257 payment_means : VISA transmission_date : 20161123120257 payment_time : 130442 payment_date : 20161123 response_code : 00 payment_certificate : fba26ece6ff6 authorisation_id : 634268 currency_code : 978 card_number : 4978.04 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 : d.bertrand10 order_id : 16580 customer_email : d.bertrand10@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 = "16581" select * from cms_frontusers where identifiant = "t.capelli20" 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 = "16581" select * from cotisations where identifiant = "t.capelli20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130624 payment_means : MASTERCARD transmission_date : 20161123120624 payment_time : 130808 payment_date : 20161123 response_code : 00 payment_certificate : c97deb9f0c6a authorisation_id : 819642 currency_code : 978 card_number : 5136.56 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 : t.capelli20 order_id : 16581 customer_email : t.capelli20@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 140759 payment_means : VISA transmission_date : 20161123130759 payment_time : 141330 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.naudot19 order_id : 16582 customer_email : r.naudot19@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 : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16583" select * from cms_frontusers where identifiant = "s.delille23" 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 = "16583" select * from cotisations where identifiant = "s.delille23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 142237 payment_means : MASTERCARD transmission_date : 20161123132237 payment_time : 142505 payment_date : 20161123 response_code : 00 payment_certificate : 459d4ca51428 authorisation_id : 282785 currency_code : 978 card_number : 5131.11 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.delille23 order_id : 16583 customer_email : s.delille23@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16584" select * from cms_frontusers where identifiant = "s.lauras19" 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 = "16584" select * from cotisations where identifiant = "s.lauras19" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "s.lauras19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143105 payment_means : VISA transmission_date : 20161123133105 payment_time : 143446 payment_date : 20161123 response_code : 00 payment_certificate : 5e3947bffe7b authorisation_id : 604625 currency_code : 978 card_number : 4978.43 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.lauras19 order_id : 16584 customer_email : s.lauras19@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16585" select * from cms_frontusers where identifiant = "y.maidon31" 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 = "16585" select * from cotisations where identifiant = "y.maidon31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145218 payment_means : VISA transmission_date : 20161123135218 payment_time : 145350 payment_date : 20161123 response_code : 00 payment_certificate : 0cb76584b6d1 authorisation_id : 351828 currency_code : 978 card_number : 4978.57 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 : y.maidon31 order_id : 16585 customer_email : y.maidon31@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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16586" select * from cms_frontusers where identifiant = "s.andrieu06" 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 = "16586" select * from cotisations where identifiant = "s.andrieu06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150107 payment_means : VISA transmission_date : 20161123140107 payment_time : 150351 payment_date : 20161123 response_code : 00 payment_certificate : 2715b20e77eb authorisation_id : 760463 currency_code : 978 card_number : 4974.55 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.andrieu06 order_id : 16586 customer_email : s.andrieu06@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16587" select * from cms_frontusers where identifiant = "jl.momper23" 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 = "16587" select * from cotisations where identifiant = "jl.momper23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151101 payment_means : MASTERCARD transmission_date : 20161123141101 payment_time : 151231 payment_date : 20161123 response_code : 00 payment_certificate : 0706bfdedf5e authorisation_id : 541710 currency_code : 978 card_number : 5135.70 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 : jl.momper23 order_id : 16587 customer_email : jl.momper23@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16588" select * from cms_frontusers where identifiant = "y.margueray26" 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 = "16588" select * from cotisations where identifiant = "y.margueray26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163338 payment_means : VISA transmission_date : 20161123153338 payment_time : 163556 payment_date : 20161123 response_code : 00 payment_certificate : 7018569032f7 authorisation_id : 325945 currency_code : 978 card_number : 4974.44 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 : y.margueray26 order_id : 16588 customer_email : y.margueray26@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16589" select * from cms_frontusers where identifiant = "v.mille22" 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 = "16589" select * from cotisations where identifiant = "v.mille22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163740 payment_means : VISA transmission_date : 20161123153740 payment_time : 163925 payment_date : 20161123 response_code : 00 payment_certificate : fe26085453b6 authorisation_id : 471466 currency_code : 978 card_number : 4533.44 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.mille22 order_id : 16589 customer_email : v.mille22@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16591" select * from cms_frontusers where identifiant = "b.martin16" 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 = "16591" select * from cotisations where identifiant = "b.martin16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164232 payment_means : VISA transmission_date : 20161123154232 payment_time : 164500 payment_date : 20161123 response_code : 00 payment_certificate : e142c5c1acf9 authorisation_id : 242735 currency_code : 978 card_number : 4978.34 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.martin16 order_id : 16591 customer_email : b.martin16@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 : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16592" select * from cms_frontusers where identifiant = "f.cronier27" 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 = "16592" select * from cotisations where identifiant = "f.cronier27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 171118 payment_means : MASTERCARD transmission_date : 20161123161118 payment_time : 172116 payment_date : 20161123 response_code : 00 payment_certificate : 12edbfb0813e authorisation_id : 747365 currency_code : 978 card_number : 5132.83 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 : f.cronier27 order_id : 16592 customer_email : f.cronier27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201711 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 : 4000 transaction_id : 172206 payment_means : MASTERCARD transmission_date : 20161123162206 payment_time : 172335 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.cronier27 order_id : 16594 customer_email : f.cronier27@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16597" select * from cms_frontusers where identifiant = "j.bellaize19" 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 = "16597" select * from cotisations where identifiant = "j.bellaize19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183023 payment_means : MASTERCARD transmission_date : 20161123173023 payment_time : 183158 payment_date : 20161123 response_code : 00 payment_certificate : 2cdab3d4b070 authorisation_id : 919125 currency_code : 978 card_number : 5136.30 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 : j.bellaize19 order_id : 16597 customer_email : j.bellaize19@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 = "16598" select * from cms_frontusers where identifiant = "l.delepine03" 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 = "16598" select * from cotisations where identifiant = "l.delepine03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183247 payment_means : MASTERCARD transmission_date : 20161123173247 payment_time : 183615 payment_date : 20161123 response_code : 00 payment_certificate : bcd48c102aed authorisation_id : 115068 currency_code : 978 card_number : 5136.75 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.delepine03 order_id : 16598 customer_email : l.delepine03@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16599" select * from cms_frontusers where identifiant = "d.rivalan24" 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 = "16599" select * from cotisations where identifiant = "d.rivalan24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184405 payment_means : CB transmission_date : 20161123174405 payment_time : 184828 payment_date : 20161123 response_code : 00 payment_certificate : 3f2d9b01e5a7 authorisation_id : 598293 currency_code : 978 card_number : 4970.77 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 : d.rivalan24 order_id : 16599 customer_email : d.rivalan24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16600" select * from cms_frontusers where identifiant = "c.rodot17" 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 = "16600" select * from cotisations where identifiant = "c.rodot17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 185323 payment_means : VISA transmission_date : 20161123175323 payment_time : 185659 payment_date : 20161123 response_code : 00 payment_certificate : b4211f0171a0 authorisation_id : 059227 currency_code : 978 card_number : 4978.20 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.rodot17 order_id : 16600 customer_email : c.rodot17@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 : 201909 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 : 194257 payment_means : VISA transmission_date : 20161123184257 payment_time : 194342 payment_date : 20161123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lefebvre06 order_id : 16601 customer_email : p.lefebvre06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16601" select * from cms_frontusers where identifiant = "p.lefebvre06" 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 = "16601" select * from cotisations where identifiant = "c.piraux03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194356 payment_means : VISA transmission_date : 20161123184356 payment_time : 194508 payment_date : 20161123 response_code : 00 payment_certificate : 81b6c70ef250 authorisation_id : 674122 currency_code : 978 card_number : 4533.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 : p.lefebvre06 order_id : 16601 customer_email : p.lefebvre06@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16602" select * from cms_frontusers where identifiant = "p.lefebvre06" 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 = "16602" select * from cotisations where identifiant = "a.dhonneur10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194557 payment_means : VISA transmission_date : 20161123184557 payment_time : 194659 payment_date : 20161123 response_code : 00 payment_certificate : 2158c4045248 authorisation_id : 183494 currency_code : 978 card_number : 4533.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 : p.lefebvre06 order_id : 16602 customer_email : p.lefebvre06@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16603" select * from cms_frontusers where identifiant = "p.stoyanova23" 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 = "16603" select * from cotisations where identifiant = "p.stoyanova23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195628 payment_means : MASTERCARD transmission_date : 20161123185628 payment_time : 195823 payment_date : 20161123 response_code : 00 payment_certificate : adee3f661ea6 authorisation_id : 858764 currency_code : 978 card_number : 5137.62 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.stoyanova23 order_id : 16603 customer_email : p.stoyanova23@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16604" select * from cms_frontusers where identifiant = "g.tartini06" 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 = "16604" select * from cotisations where identifiant = "g.tartini06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200445 payment_means : MASTERCARD transmission_date : 20161123190445 payment_time : 200634 payment_date : 20161123 response_code : 00 payment_certificate : f756b75300e9 authorisation_id : 581582 currency_code : 978 card_number : 5137.62 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.tartini06 order_id : 16604 customer_email : g.tartini06@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16606" select * from cms_frontusers where identifiant = "jm.aupee28" 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 = "16606" select * from cotisations where identifiant = "m.fines03" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "jj.zanchetta31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 201111 payment_means : VISA transmission_date : 20161123191111 payment_time : 201252 payment_date : 20161123 response_code : 00 payment_certificate : b22c5cde7712 authorisation_id : 416243 currency_code : 978 card_number : 4978.10 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 : jm.aupee28 order_id : 16606 customer_email : jm.aupee28@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16608" select * from cms_frontusers where identifiant = "pq.bani16" 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 = "16608" select * from cotisations where identifiant = "pq.bani16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202151 payment_means : VISA transmission_date : 20161123192151 payment_time : 202329 payment_date : 20161123 response_code : 00 payment_certificate : 54ce49eeeb7e authorisation_id : 993386 currency_code : 978 card_number : 4976.30 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 : pq.bani16 order_id : 16608 customer_email : pq.bani16@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 : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16609" select * from cms_frontusers where identifiant = "v.mestreau05" 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 = "16609" select * from cotisations where identifiant = "v.mestreau05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202754 payment_means : MASTERCARD transmission_date : 20161123192754 payment_time : 202926 payment_date : 20161123 response_code : 00 payment_certificate : d37a8a3c4be4 authorisation_id : 653933 currency_code : 978 card_number : 5131.28 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.mestreau05 order_id : 16609 customer_email : v.mestreau05@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 = "16610" select * from cms_frontusers where identifiant = "a.moreau28" 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 = "16610" select * from cotisations where identifiant = "a.moreau28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202934 payment_means : CB transmission_date : 20161123192934 payment_time : 203052 payment_date : 20161123 response_code : 00 payment_certificate : 9b1c7cdfa30c authorisation_id : 867651 currency_code : 978 card_number : 5133.18 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.moreau28 order_id : 16610 customer_email : a.moreau28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16611" select * from cms_frontusers where identifiant = "v.mestreau05" 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 = "16611" select * from cotisations where identifiant = "f.burkhalter23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203005 payment_means : VISA transmission_date : 20161123193005 payment_time : 203308 payment_date : 20161123 response_code : 00 payment_certificate : d778c3875030 authorisation_id : 034620 currency_code : 978 card_number : 4974.53 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.mestreau05 order_id : 16611 customer_email : v.mestreau05@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 = "16613" select * from cms_frontusers where identifiant = "c.gillet01" 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 = "16613" select * from cotisations where identifiant = "c.gillet01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205439 payment_means : MASTERCARD transmission_date : 20161123195439 payment_time : 205548 payment_date : 20161123 response_code : 00 payment_certificate : 35f075a56e3b authorisation_id : 614883 currency_code : 978 card_number : 5132.57 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.gillet01 order_id : 16613 customer_email : c.gillet01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16612" select * from cms_frontusers where identifiant = "a.thevenet04" 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 = "16612" select * from cotisations where identifiant = "a.thevenet04" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.thevenet04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205346 payment_means : VISA transmission_date : 20161123195346 payment_time : 205740 payment_date : 20161123 response_code : 00 payment_certificate : ee198d7ab7f8 authorisation_id : 452056 currency_code : 978 card_number : 4533.76 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.thevenet04 order_id : 16612 customer_email : a.thevenet04@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16614" select * from cms_frontusers where identifiant = "a.thubin11" 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 = "16614" select * from cotisations where identifiant = "a.thubin11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205925 payment_means : VISA transmission_date : 20161123195925 payment_time : 210835 payment_date : 20161123 response_code : 00 payment_certificate : c96fae3d12d0 authorisation_id : 220131 currency_code : 978 card_number : 4978.65 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.thubin11 order_id : 16614 customer_email : a.thubin11@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 = "16615" select * from cms_frontusers where identifiant = "j.piterboth21" 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 = "16615" select * from cotisations where identifiant = "j.piterboth21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211723 payment_means : VISA transmission_date : 20161123201723 payment_time : 212059 payment_date : 20161123 response_code : 00 payment_certificate : 4b8cac5f3bd6 authorisation_id : 049699 currency_code : 978 card_number : 4978.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 : j.piterboth21 order_id : 16615 customer_email : j.piterboth21@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16616" select * from cms_frontusers where identifiant = "f.lavielle21" 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 = "16616" select * from cotisations where identifiant = "f.lavielle21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211315 payment_means : MASTERCARD transmission_date : 20161123201315 payment_time : 212134 payment_date : 20161123 response_code : 00 payment_certificate : 39c66a5d64a9 authorisation_id : 612566 currency_code : 978 card_number : 5131.28 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 : f.lavielle21 order_id : 16616 customer_email : f.lavielle21@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16618" select * from cms_frontusers where identifiant = "l.robert05" 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 = "16618" select * from cotisations where identifiant = "l.robert05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212236 payment_means : MASTERCARD transmission_date : 20161123202236 payment_time : 212423 payment_date : 20161123 response_code : 00 payment_certificate : cdebec49fcdd authorisation_id : 395306 currency_code : 978 card_number : 5133.03 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.robert05 order_id : 16618 customer_email : l.robert05@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 = "16619" select * from cms_frontusers where identifiant = "f.lavielle21" 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 = "16619" select * from cotisations where identifiant = "f.lavielle21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212259 payment_means : MASTERCARD transmission_date : 20161123202259 payment_time : 212541 payment_date : 20161123 response_code : 00 payment_certificate : e318e97b9557 authorisation_id : 521362 currency_code : 978 card_number : 5131.28 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 : f.lavielle21 order_id : 16619 customer_email : f.lavielle21@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16620" select * from cms_frontusers where identifiant = "p.briodeau08" 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 = "16620" select * from cotisations where identifiant = "p.briodeau08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212314 payment_means : MASTERCARD transmission_date : 20161123202314 payment_time : 212842 payment_date : 20161123 response_code : 00 payment_certificate : 3ce38a25a9e6 authorisation_id : 319346 currency_code : 978 card_number : 5131.92 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.briodeau08 order_id : 16620 customer_email : p.briodeau08@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 : 201804 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 : 212910 payment_means : MASTERCARD transmission_date : 20161123202910 payment_time : 213006 payment_date : 20161123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.mirault07 order_id : 16623 customer_email : e.mirault07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16623" select * from cms_frontusers where identifiant = "e.mirault07" 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 = "16623" select * from cotisations where identifiant = "e.mirault07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213024 payment_means : MASTERCARD transmission_date : 20161123203024 payment_time : 213500 payment_date : 20161123 response_code : 00 payment_certificate : 47c76ff41e04 authorisation_id : 357310 currency_code : 978 card_number : 5131.18 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 : e.mirault07 order_id : 16623 customer_email : e.mirault07@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 = "16629" select * from cms_frontusers where identifiant = "v.hild30" 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 = "16629" select * from cotisations where identifiant = "v.hild30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213638 payment_means : MASTERCARD transmission_date : 20161123203638 payment_time : 213724 payment_date : 20161123 response_code : 00 payment_certificate : d88f3a745a4e authorisation_id : 329157 currency_code : 978 card_number : 5133.39 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.hild30 order_id : 16629 customer_email : v.hild30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16627" select * from cms_frontusers where identifiant = "t.weinelt02" 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 = "16627" select * from cotisations where identifiant = "t.weinelt02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213552 payment_means : VISA transmission_date : 20161123203552 payment_time : 213910 payment_date : 20161123 response_code : 00 payment_certificate : 2f2f60f8ee02 authorisation_id : 033625 currency_code : 978 card_number : 4973.62 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 : t.weinelt02 order_id : 16627 customer_email : t.weinelt02@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16625" select * from cms_frontusers where identifiant = "t.rousseau16" 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 = "16625" select * from cotisations where identifiant = "t.rousseau16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213421 payment_means : MASTERCARD transmission_date : 20161123203421 payment_time : 213921 payment_date : 20161123 response_code : 00 payment_certificate : 87effc376151 authorisation_id : 641413 currency_code : 978 card_number : 5132.13 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 : t.rousseau16 order_id : 16625 customer_email : t.rousseau16@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213622 payment_means : MASTERCARD transmission_date : 20161123203622 payment_time : 214038 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.goubet01 order_id : 16628 customer_email : s.goubet01@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16630" select * from cms_frontusers where identifiant = "f.maxel11" 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 = "16630" select * from cotisations where identifiant = "f.maxel11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213951 payment_means : VISA transmission_date : 20161123203951 payment_time : 214512 payment_date : 20161123 response_code : 00 payment_certificate : dcc4e25b273c authorisation_id : 120826 currency_code : 978 card_number : 4973.37 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 : f.maxel11 order_id : 16630 customer_email : f.maxel11@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16631" select * from cms_frontusers where identifiant = "v.sanchezgil01" 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 = "16631" select * from cotisations where identifiant = "v.sanchezgil01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214937 payment_means : VISA transmission_date : 20161123204937 payment_time : 215100 payment_date : 20161123 response_code : 00 payment_certificate : af2137765692 authorisation_id : 516573 currency_code : 978 card_number : 4970.30 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.sanchezgil01 order_id : 16631 customer_email : v.sanchezgil01@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 = "16632" select * from cms_frontusers where identifiant = "t.rivalin02" 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 = "16632" select * from cotisations where identifiant = "t.rivalin02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215237 payment_means : VISA transmission_date : 20161123205237 payment_time : 215352 payment_date : 20161123 response_code : 00 payment_certificate : 3d9dae28b8d6 authorisation_id : 266462 currency_code : 978 card_number : 4975.17 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 : t.rivalin02 order_id : 16632 customer_email : t.rivalin02@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 : 201712 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 : 4000 transaction_id : 212715 payment_means : MASTERCARD transmission_date : 20161123202715 payment_time : 215542 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l1.martin06 order_id : 16622 customer_email : l1.martin06@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16634" select * from cms_frontusers where identifiant = "o.contet27" 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 = "16634" select * from cotisations where identifiant = "o.contet27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220129 payment_means : VISA transmission_date : 20161123210129 payment_time : 220322 payment_date : 20161123 response_code : 00 payment_certificate : 93c014b55aa0 authorisation_id : 726490 currency_code : 978 card_number : 4975.40 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 : o.contet27 order_id : 16634 customer_email : o.contet27@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16635" select * from cms_frontusers where identifiant = "a.dematospaulo04" 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 = "16635" select * from cotisations where identifiant = "a.dematospaulo04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220152 payment_means : MASTERCARD transmission_date : 20161123210152 payment_time : 220328 payment_date : 20161123 response_code : 00 payment_certificate : 94e9a7ae8cdf authorisation_id : 322147 currency_code : 978 card_number : 5136.96 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.dematospaulo04 order_id : 16635 customer_email : a.dematospaulo04@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 : 201803 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 : 4000 transaction_id : 220454 payment_means : MASTERCARD transmission_date : 20161123210454 payment_time : 220610 payment_date : 20161123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l1.martin06 order_id : 16633 customer_email : l1.martin06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201803 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 : 4000 transaction_id : 220913 payment_means : MASTERCARD transmission_date : 20161123210913 payment_time : 221450 payment_date : 20161123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l1.martin06 order_id : 16633 customer_email : l1.martin06@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16636" select * from cms_frontusers where identifiant = "s.duchemin13" 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 = "16636" select * from cotisations where identifiant = "s.duchemin13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221810 payment_means : MASTERCARD transmission_date : 20161123211810 payment_time : 221945 payment_date : 20161123 response_code : 00 payment_certificate : 357d870614ba authorisation_id : 645412 currency_code : 978 card_number : 5132.70 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.duchemin13 order_id : 16636 customer_email : s.duchemin13@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 = "16637" select * from cms_frontusers where identifiant = "a.mayer02" 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 = "16637" select * from cotisations where identifiant = "a.mayer02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 233957 payment_means : MASTERCARD transmission_date : 20161123223957 payment_time : 234420 payment_date : 20161123 response_code : 00 payment_certificate : 596eb6f0a60c authorisation_id : 855452 currency_code : 978 card_number : 5132.53 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.mayer02 order_id : 16637 customer_email : a.mayer02@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 : -------------------------------------------