select * from cotisations_commande where id = "15801" select * from cms_frontusers where identifiant = "l.biry03" 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 = "15801" select * from cotisations where identifiant = "l.biry03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 011148 payment_means : VISA transmission_date : 20161114001148 payment_time : 011319 payment_date : 20161114 response_code : 00 payment_certificate : 71fd2febe716 authorisation_id : 176454 currency_code : 978 card_number : 4974.33 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.biry03 order_id : 15801 customer_email : l.biry03@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 = "15802" select * from cms_frontusers where identifiant = "g.suteau25" 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 = "15802" select * from cotisations where identifiant = "g.suteau25" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "g.suteau25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 065232 payment_means : MASTERCARD transmission_date : 20161114055232 payment_time : 065619 payment_date : 20161114 response_code : 00 payment_certificate : 6ff29f3fb1f4 authorisation_id : 862749 currency_code : 978 card_number : 5132.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 : g.suteau25 order_id : 15802 customer_email : g.suteau25@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 = "15803" select * from cms_frontusers where identifiant = "p.jahan14" 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 = "15803" select * from cotisations where identifiant = "p.jahan14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070957 payment_means : MASTERCARD transmission_date : 20161114060957 payment_time : 071249 payment_date : 20161114 response_code : 00 payment_certificate : 94ffa8199ea0 authorisation_id : 458344 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 : p.jahan14 order_id : 15803 customer_email : p.jahan14@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 : 201710 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 : 081424 payment_means : VISA transmission_date : 20161114071424 payment_time : 082723 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.37 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 : a.barrera01 order_id : 15805 customer_email : a.barrera01@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 : 201805 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 : 082737 payment_means : VISA transmission_date : 20161114072737 payment_time : 083315 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.37 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 : a.barrera01 order_id : 15805 customer_email : a.barrera01@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 : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15806" select * from cms_frontusers where identifiant = "a.geauffroy17" 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 = "15806" select * from cotisations where identifiant = "a.geauffroy17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090505 payment_means : VISA transmission_date : 20161114080505 payment_time : 090636 payment_date : 20161114 response_code : 00 payment_certificate : 030e0be85456 authorisation_id : 616314 currency_code : 978 card_number : 4972.69 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.geauffroy17 order_id : 15806 customer_email : a.geauffroy17@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 = "15808" select * from cms_frontusers where identifiant = "b2.thevenin24" 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 = "15808" select * from cotisations where identifiant = "b2.thevenin24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091013 payment_means : MASTERCARD transmission_date : 20161114081013 payment_time : 091143 payment_date : 20161114 response_code : 00 payment_certificate : 50d8978ac322 authorisation_id : 571281 currency_code : 978 card_number : 5131.12 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 : b2.thevenin24 order_id : 15808 customer_email : b2.thevenin24@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 = "15807" select * from cms_frontusers where identifiant = "a.barrera01" 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 = "15807" select * from cotisations where identifiant = "a.barrera01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090848 payment_means : VISA transmission_date : 20161114080848 payment_time : 091650 payment_date : 20161114 response_code : 00 payment_certificate : 0f44b5dab503 authorisation_id : 156769 currency_code : 978 card_number : 4970.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 : a.barrera01 order_id : 15807 customer_email : a.barrera01@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 = "15809" select * from cms_frontusers where identifiant = "r.lelievre01" 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 = "15809" select * from cotisations where identifiant = "r.lelievre01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092529 payment_means : MASTERCARD transmission_date : 20161114082529 payment_time : 092659 payment_date : 20161114 response_code : 00 payment_certificate : d91311ecab06 authorisation_id : 511386 currency_code : 978 card_number : 5137.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 : r.lelievre01 order_id : 15809 customer_email : r.lelievre01@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 = "15810" select * from cms_frontusers where identifiant = "g.istace16" 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 = "15810" select * from cotisations where identifiant = "g.istace16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093650 payment_means : MASTERCARD transmission_date : 20161114083650 payment_time : 093815 payment_date : 20161114 response_code : 00 payment_certificate : 5f559a1dd288 authorisation_id : 037821 currency_code : 978 card_number : 5131.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 : g.istace16 order_id : 15810 customer_email : g.istace16@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 = "15812" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "15812" select * from cotisations where identifiant = "j.rousseau18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105557 payment_means : VISA transmission_date : 20161114095557 payment_time : 110010 payment_date : 20161114 response_code : 00 payment_certificate : 57bf72e069a9 authorisation_id : 123119 currency_code : 978 card_number : 4970.24 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.rousseau18 order_id : 15812 customer_email : j.rousseau18@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15814" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "15814" select * from cotisations where identifiant = "f.merlet08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110751 payment_means : VISA transmission_date : 20161114100751 payment_time : 110920 payment_date : 20161114 response_code : 00 payment_certificate : d13ba328508d authorisation_id : 146558 currency_code : 978 card_number : 4970.24 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.rousseau18 order_id : 15814 customer_email : j.rousseau18@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15815" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "15815" select * from cotisations where identifiant = "j.choiselle10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111115 payment_means : VISA transmission_date : 20161114101115 payment_time : 111227 payment_date : 20161114 response_code : 00 payment_certificate : 4a5e577816c1 authorisation_id : 310815 currency_code : 978 card_number : 4970.24 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.rousseau18 order_id : 15815 customer_email : j.rousseau18@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15816" select * from cms_frontusers where identifiant = "j.rousseau18" 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 = "15816" select * from cotisations where identifiant = "g.guitteny25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111332 payment_means : VISA transmission_date : 20161114101332 payment_time : 111507 payment_date : 20161114 response_code : 00 payment_certificate : a3bb4afb0f48 authorisation_id : 283165 currency_code : 978 card_number : 4970.24 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.rousseau18 order_id : 15816 customer_email : j.rousseau18@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 : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15819" select * from cms_frontusers where identifiant = "r.delima25" 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 = "15819" select * from cotisations where identifiant = "r.delima25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133136 payment_means : VISA transmission_date : 20161114123136 payment_time : 133313 payment_date : 20161114 response_code : 00 payment_certificate : 92fb45ae1bcf authorisation_id : 525322 currency_code : 978 card_number : 4975.48 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.delima25 order_id : 15819 customer_email : r.delima25@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15820" select * from cms_frontusers where identifiant = "j.poirier02" 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 = "15820" select * from cotisations where identifiant = "j.poirier02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134235 payment_means : VISA transmission_date : 20161114124235 payment_time : 134410 payment_date : 20161114 response_code : 00 payment_certificate : f97e5a563478 authorisation_id : 443625 currency_code : 978 card_number : 4978.46 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.poirier02 order_id : 15820 customer_email : j.poirier02@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 = "15822" select * from cms_frontusers where identifiant = "f.bremaud19" 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 = "15822" select * from cotisations where identifiant = "f.bremaud19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135753 payment_means : VISA transmission_date : 20161114125753 payment_time : 140010 payment_date : 20161114 response_code : 00 payment_certificate : 7761c21fde10 authorisation_id : 377169 currency_code : 978 card_number : 4975.32 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.bremaud19 order_id : 15822 customer_email : f.bremaud19@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 = "15825" select * from cms_frontusers where identifiant = "g.morellec25" 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 = "15825" select * from cotisations where identifiant = "g.morellec25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 143602 payment_means : MASTERCARD transmission_date : 20161114133602 payment_time : 143942 payment_date : 20161114 response_code : 00 payment_certificate : 3f10f0a09095 authorisation_id : 271163 currency_code : 978 card_number : 5130.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 : g.morellec25 order_id : 15825 customer_email : g.morellec25@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 = "15826" select * from cms_frontusers where identifiant = "jl.pistre26" 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 = "15826" select * from cotisations where identifiant = "jl.pistre26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150311 payment_means : MASTERCARD transmission_date : 20161114140311 payment_time : 150502 payment_date : 20161114 response_code : 00 payment_certificate : 846643723767 authorisation_id : 556403 currency_code : 978 card_number : 5131.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 : jl.pistre26 order_id : 15826 customer_email : jl.pistre26@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 = "15827" select * from cms_frontusers where identifiant = "g.morellec25" 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 = "15827" select * from cotisations where identifiant = "g.morellec25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 152450 payment_means : MASTERCARD transmission_date : 20161114142450 payment_time : 152745 payment_date : 20161114 response_code : 00 payment_certificate : 06e325664d22 authorisation_id : 346994 currency_code : 978 card_number : 5130.48 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.morellec25 order_id : 15827 customer_email : g.morellec25@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 = "15828" select * from cms_frontusers where identifiant = "g.dutertre16" 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 = "15828" select * from cotisations where identifiant = "g.dutertre16" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "g.dutertre16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153043 payment_means : VISA transmission_date : 20161114143043 payment_time : 153203 payment_date : 20161114 response_code : 00 payment_certificate : f6e941fe53ca authorisation_id : 371946 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 : g.dutertre16 order_id : 15828 customer_email : g.dutertre16@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 : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15829" select * from cms_frontusers where identifiant = "l.geraud15" 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 = "15829" select * from cotisations where identifiant = "l.geraud15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154655 payment_means : MASTERCARD transmission_date : 20161114144655 payment_time : 154920 payment_date : 20161114 response_code : 00 payment_certificate : 50a48d4f0a61 authorisation_id : 868546 currency_code : 978 card_number : 5500.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 : l.geraud15 order_id : 15829 customer_email : l.geraud15@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 : 201907 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15831" select * from cms_frontusers where identifiant = "s.fievre24" 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 = "15831" select * from cotisations where identifiant = "s.fievre24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162439 payment_means : VISA transmission_date : 20161114152439 payment_time : 162746 payment_date : 20161114 response_code : 00 payment_certificate : 5a160a04fd3c authorisation_id : 130356 currency_code : 978 card_number : 4978.98 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.fievre24 order_id : 15831 customer_email : s.fievre24@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15832" select * from cms_frontusers where identifiant = "b.bachelier11" 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 = "15832" select * from cotisations where identifiant = "b.bachelier11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163939 payment_means : MASTERCARD transmission_date : 20161114153939 payment_time : 164109 payment_date : 20161114 response_code : 00 payment_certificate : 1d7cc41571d9 authorisation_id : 026430 currency_code : 978 card_number : 5132.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 : b.bachelier11 order_id : 15832 customer_email : b.bachelier11@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 = "15835" select * from cms_frontusers where identifiant = "n.fourny31" 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 = "15835" select * from cotisations where identifiant = "n.fourny31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165451 payment_means : MASTERCARD transmission_date : 20161114155451 payment_time : 165807 payment_date : 20161114 response_code : 00 payment_certificate : 366c6d019729 authorisation_id : 756267 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 : n.fourny31 order_id : 15835 customer_email : n.fourny31@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 = "15837" select * from cms_frontusers where identifiant = "j.guignard29" 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 = "15837" select * from cotisations where identifiant = "j.guignard29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171642 payment_means : VISA transmission_date : 20161114161642 payment_time : 171821 payment_date : 20161114 response_code : 00 payment_certificate : c55b417c9201 authorisation_id : 505046 currency_code : 978 card_number : 4978.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 : j.guignard29 order_id : 15837 customer_email : j.guignard29@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 = "15836" select * from cms_frontusers where identifiant = "a.bresolin23" 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 = "15836" select * from cotisations where identifiant = "a.bresolin23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171638 payment_means : MASTERCARD transmission_date : 20161114161638 payment_time : 171945 payment_date : 20161114 response_code : 00 payment_certificate : 404db85c3a79 authorisation_id : 522237 currency_code : 978 card_number : 5137.90 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.bresolin23 order_id : 15836 customer_email : a.bresolin23@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 = "15838" 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 = "15838" select * from cotisations where identifiant = "l.ruffier10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172408 payment_means : VISA transmission_date : 20161114162408 payment_time : 172620 payment_date : 20161114 response_code : 00 payment_certificate : 0d8b902ddce6 authorisation_id : 192663 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 : 15838 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 = "15834" select * from cms_frontusers where identifiant = "p.besse07" 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 = "15834" select * from cotisations where identifiant = "p.besse07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164436 payment_means : VISA transmission_date : 20161114154436 payment_time : 173001 payment_date : 20161114 response_code : 00 payment_certificate : 2ebc409a9abb authorisation_id : 261542 currency_code : 978 card_number : 4533.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 : p.besse07 order_id : 15834 customer_email : p.besse07@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 = "15839" select * from cms_frontusers where identifiant = "h.boulard07" 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 = "15839" select * from cotisations where identifiant = "h.boulard07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173741 payment_means : VISA transmission_date : 20161114163741 payment_time : 174003 payment_date : 20161114 response_code : 00 payment_certificate : 8eb87f02cd9e authorisation_id : 986713 currency_code : 978 card_number : 4975.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 : h.boulard07 order_id : 15839 customer_email : h.boulard07@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174001 payment_means : MASTERCARD transmission_date : 20161114164001 payment_time : 174525 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.27 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.marlot09 order_id : 15840 customer_email : m.marlot09@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 = "15843" select * from cms_frontusers where identifiant = "n.drouet06" 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 = "15843" select * from cotisations where identifiant = "n.drouet06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175802 payment_means : VISA transmission_date : 20161114165802 payment_time : 175934 payment_date : 20161114 response_code : 00 payment_certificate : 9a4fbebca9c8 authorisation_id : 791574 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 : n.drouet06 order_id : 15843 customer_email : n.drouet06@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 = "15840" select * from cms_frontusers where identifiant = "m.marlot09" 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 = "15840" select * from cotisations where identifiant = "m.marlot09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175140 payment_means : MASTERCARD transmission_date : 20161114165140 payment_time : 175950 payment_date : 20161114 response_code : 00 payment_certificate : 3e54de7cb866 authorisation_id : 811990 currency_code : 978 card_number : 5131.27 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.marlot09 order_id : 15840 customer_email : m.marlot09@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 = "15841" select * from cms_frontusers where identifiant = "a.treille17" 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 = "15841" select * from cotisations where identifiant = "a.treille17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175617 payment_means : MASTERCARD transmission_date : 20161114165617 payment_time : 175954 payment_date : 20161114 response_code : 00 payment_certificate : 503459b7552a authorisation_id : 583666 currency_code : 978 card_number : 5350.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 : a.treille17 order_id : 15841 customer_email : a.treille17@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 = "15844" select * from cms_frontusers where identifiant = "a.treille17" 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 = "15844" select * from cotisations where identifiant = "v.treille13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 180421 payment_means : MASTERCARD transmission_date : 20161114170421 payment_time : 180638 payment_date : 20161114 response_code : 00 payment_certificate : b723ba25cc34 authorisation_id : 514349 currency_code : 978 card_number : 5350.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 : a.treille17 order_id : 15844 customer_email : a.treille17@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 = "15845" select * from cms_frontusers where identifiant = "t.hubrecht19" 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 = "15845" select * from cotisations where identifiant = "t.hubrecht19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180905 payment_means : MASTERCARD transmission_date : 20161114170905 payment_time : 181214 payment_date : 20161114 response_code : 00 payment_certificate : b291f4ab1852 authorisation_id : 355789 currency_code : 978 card_number : 5137.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 : t.hubrecht19 order_id : 15845 customer_email : t.hubrecht19@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 = "15846" select * from cms_frontusers where identifiant = "b.bouguet08" 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 = "15846" select * from cotisations where identifiant = "b.bouguet08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181200 payment_means : MASTERCARD transmission_date : 20161114171200 payment_time : 181353 payment_date : 20161114 response_code : 00 payment_certificate : f530a9ed5ee6 authorisation_id : 466252 currency_code : 978 card_number : 5132.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 : b.bouguet08 order_id : 15846 customer_email : b.bouguet08@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182431 payment_means : VISA transmission_date : 20161114172431 payment_time : 183023 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.26 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 : c.durand22 order_id : 15847 customer_email : c.durand22@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15848" select * from cms_frontusers where identifiant = "c.durand22" 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 = "15848" select * from cotisations where identifiant = "c.durand22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183401 payment_means : VISA transmission_date : 20161114173401 payment_time : 183604 payment_date : 20161114 response_code : 00 payment_certificate : ff99523c8867 authorisation_id : 794268 currency_code : 978 card_number : 4970.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 : c.durand22 order_id : 15848 customer_email : c.durand22@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 = "15849" select * from cms_frontusers where identifiant = "a.louisin17" 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 = "15849" select * from cotisations where identifiant = "a.louisin17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183721 payment_means : VISA transmission_date : 20161114173721 payment_time : 184010 payment_date : 20161114 response_code : 00 payment_certificate : 137f3c9abbce authorisation_id : 354704 currency_code : 978 card_number : 4975.68 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.louisin17 order_id : 15849 customer_email : a.louisin17@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 : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15851" select * from cms_frontusers where identifiant = "ph.bonato19" 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 = "15851" select * from cotisations where identifiant = "ph.bonato19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184023 payment_means : VISA transmission_date : 20161114174023 payment_time : 184221 payment_date : 20161114 response_code : 00 payment_certificate : e341b0728e5f authorisation_id : 910216 currency_code : 978 card_number : 4973.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 : ph.bonato19 order_id : 15851 customer_email : ph.bonato19@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 : 8000 transaction_id : 183949 payment_means : MASTERCARD transmission_date : 20161114173949 payment_time : 184256 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.08 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 : n.lefebvre15 order_id : 15850 customer_email : n.lefebvre15@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 : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15852" select * from cms_frontusers where identifiant = "p.mercier15" 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 = "15852" select * from cotisations where identifiant = "p.mercier15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184102 payment_means : VISA transmission_date : 20161114174102 payment_time : 184315 payment_date : 20161114 response_code : 00 payment_certificate : c5ad24998143 authorisation_id : 722400 currency_code : 978 card_number : 4978.98 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.mercier15 order_id : 15852 customer_email : p.mercier15@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 = "15853" select * from cms_frontusers where identifiant = "a.bourigaud08" 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 = "15853" select * from cotisations where identifiant = "a.bourigaud08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185626 payment_means : VISA transmission_date : 20161114175626 payment_time : 185831 payment_date : 20161114 response_code : 00 payment_certificate : fba0658576e7 authorisation_id : 296158 currency_code : 978 card_number : 4978.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 : a.bourigaud08 order_id : 15853 customer_email : a.bourigaud08@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15854" select * from cms_frontusers where identifiant = "a.granville19" 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 = "15854" select * from cotisations where identifiant = "a.granville19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193659 payment_means : MASTERCARD transmission_date : 20161114183659 payment_time : 193842 payment_date : 20161114 response_code : 00 payment_certificate : e47e392a7a70 authorisation_id : 515357 currency_code : 978 card_number : 5132.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 : a.granville19 order_id : 15854 customer_email : a.granville19@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 = "15855" select * from cms_frontusers where identifiant = "g.bueb03" 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 = "15855" select * from cotisations where identifiant = "g.bueb03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194124 payment_means : VISA transmission_date : 20161114184124 payment_time : 194343 payment_date : 20161114 response_code : 00 payment_certificate : 61a3ac227be9 authorisation_id : 136337 currency_code : 978 card_number : 4974.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 : g.bueb03 order_id : 15855 customer_email : g.bueb03@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 : 194247 payment_means : VISA transmission_date : 20161114184247 payment_time : 194812 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.20 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 : b.rochette25 order_id : 15856 customer_email : b.rochette25@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15857" select * from cms_frontusers where identifiant = "l.alig25" 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 = "15857" select * from cotisations where identifiant = "l.alig25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194547 payment_means : VISA transmission_date : 20161114184547 payment_time : 194816 payment_date : 20161114 response_code : 00 payment_certificate : cc7c242754d7 authorisation_id : 625243 currency_code : 978 card_number : 4973.93 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.alig25 order_id : 15857 customer_email : l.alig25@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 = "15859" select * from cms_frontusers where identifiant = "p.pepin04" 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 = "15859" select * from cotisations where identifiant = "p.pepin04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200249 payment_means : MASTERCARD transmission_date : 20161114190249 payment_time : 200603 payment_date : 20161114 response_code : 00 payment_certificate : c7255afbeaa3 authorisation_id : 252375 currency_code : 978 card_number : 5132.46 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.pepin04 order_id : 15859 customer_email : p.pepin04@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 = "15861" select * from cms_frontusers where identifiant = "b.astruc21" 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 = "15861" select * from cotisations where identifiant = "b.astruc21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201113 payment_means : MASTERCARD transmission_date : 20161114191113 payment_time : 201741 payment_date : 20161114 response_code : 00 payment_certificate : 7d1140d81092 authorisation_id : 318318 currency_code : 978 card_number : 5136.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 : b.astruc21 order_id : 15861 customer_email : b.astruc21@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 = "15858" select * from cms_frontusers where identifiant = "j.beaudoin05" 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 = "15858" select * from cotisations where identifiant = "j.beaudoin05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195704 payment_means : MASTERCARD transmission_date : 20161114185704 payment_time : 201826 payment_date : 20161114 response_code : 00 payment_certificate : 97c1857faf27 authorisation_id : 636898 currency_code : 978 card_number : 5132.86 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.beaudoin05 order_id : 15858 customer_email : j.beaudoin05@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 = "15863" select * from cms_frontusers where identifiant = "l.lambert04" 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 = "15863" select * from cotisations where identifiant = "l.lambert04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202130 payment_means : MASTERCARD transmission_date : 20161114192130 payment_time : 202511 payment_date : 20161114 response_code : 00 payment_certificate : f062e0c5e2fd authorisation_id : 754683 currency_code : 978 card_number : 5131.38 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.lambert04 order_id : 15863 customer_email : l.lambert04@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 : ------------------------------------------- select * from cotisations_commande where id = "15864" select * from cms_frontusers where identifiant = "c.dubon15" 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 = "15864" select * from cotisations where identifiant = "c.dubon15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202748 payment_means : MASTERCARD transmission_date : 20161114192748 payment_time : 202854 payment_date : 20161114 response_code : 00 payment_certificate : 8fea2ea04318 authorisation_id : 474426 currency_code : 978 card_number : 5131.91 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.dubon15 order_id : 15864 customer_email : c.dubon15@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 = "15866" select * from cms_frontusers where identifiant = "l.menet17" 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 = "15866" select * from cotisations where identifiant = "l.menet17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203042 payment_means : MASTERCARD transmission_date : 20161114193042 payment_time : 203313 payment_date : 20161114 response_code : 00 payment_certificate : 05b8db2b683b authorisation_id : 190572 currency_code : 978 card_number : 5131.48 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.menet17 order_id : 15866 customer_email : l.menet17@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 = "15867" select * from cms_frontusers where identifiant = "jb.fior12" 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 = "15867" select * from cotisations where identifiant = "jb.fior12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203756 payment_means : MASTERCARD transmission_date : 20161114193756 payment_time : 203947 payment_date : 20161114 response_code : 00 payment_certificate : 42abec1b4198 authorisation_id : 816937 currency_code : 978 card_number : 5131.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 : jb.fior12 order_id : 15867 customer_email : jb.fior12@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 = "15869" select * from cms_frontusers where identifiant = "jm.galmiche09" 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 = "15869" select * from cotisations where identifiant = "jm.galmiche09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204206 payment_means : MASTERCARD transmission_date : 20161114194206 payment_time : 204311 payment_date : 20161114 response_code : 00 payment_certificate : da1257abe272 authorisation_id : 643286 currency_code : 978 card_number : 5132.60 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.galmiche09 order_id : 15869 customer_email : jm.galmiche09@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 : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15870" select * from cms_frontusers where identifiant = "s.rathfuchs30" 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 = "15870" select * from cotisations where identifiant = "s.rathfuchs30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204836 payment_means : VISA transmission_date : 20161114194836 payment_time : 204954 payment_date : 20161114 response_code : 00 payment_certificate : 711065ee63dd authorisation_id : 633050 currency_code : 978 card_number : 4533.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 : s.rathfuchs30 order_id : 15870 customer_email : s.rathfuchs30@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 = "15871" select * from cms_frontusers where identifiant = "m.maillard11" 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 = "15871" select * from cotisations where identifiant = "m.maillard11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205010 payment_means : MASTERCARD transmission_date : 20161114195010 payment_time : 205251 payment_date : 20161114 response_code : 00 payment_certificate : 0256ca51009f authorisation_id : 403135 currency_code : 978 card_number : 5136.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 : m.maillard11 order_id : 15871 customer_email : m.maillard11@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200620 payment_means : VISA transmission_date : 20161114190620 payment_time : 205554 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.17 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.mcavoy27 order_id : 15860 customer_email : t.mcavoy27@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 = "15872" select * from cms_frontusers where identifiant = "a.cecillon27" 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 = "15872" select * from cotisations where identifiant = "a.cecillon27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205510 payment_means : VISA transmission_date : 20161114195510 payment_time : 205632 payment_date : 20161114 response_code : 00 payment_certificate : 64d5c8044c2d authorisation_id : 395834 currency_code : 978 card_number : 4970.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 : a.cecillon27 order_id : 15872 customer_email : a.cecillon27@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 = "15873" select * from cms_frontusers where identifiant = "f.lott05" 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 = "15873" select * from cotisations where identifiant = "f.lott05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210248 payment_means : MASTERCARD transmission_date : 20161114200248 payment_time : 210424 payment_date : 20161114 response_code : 00 payment_certificate : e45adb9f89ff authorisation_id : 241447 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.lott05 order_id : 15873 customer_email : f.lott05@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210307 payment_means : MASTERCARD transmission_date : 20161114200307 payment_time : 210535 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.18 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 : a.moreau28 order_id : 15874 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_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15875" select * from cms_frontusers where identifiant = "f.lott05" 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 = "15875" select * from cotisations where identifiant = "f.lott05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210503 payment_means : MASTERCARD transmission_date : 20161114200503 payment_time : 210607 payment_date : 20161114 response_code : 00 payment_certificate : 6ef522732cbb authorisation_id : 146378 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.lott05 order_id : 15875 customer_email : f.lott05@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 = "15876" select * from cms_frontusers where identifiant = "c.inglevert29" 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 = "15876" select * from cotisations where identifiant = "c.inglevert29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211715 payment_means : MASTERCARD transmission_date : 20161114201715 payment_time : 211848 payment_date : 20161114 response_code : 00 payment_certificate : 5223148378b6 authorisation_id : 135328 currency_code : 978 card_number : 5137.97 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.inglevert29 order_id : 15876 customer_email : c.inglevert29@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 = "15877" select * from cms_frontusers where identifiant = "n.migneaux06" 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 = "15877" select * from cotisations where identifiant = "n.migneaux06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213101 payment_means : MASTERCARD transmission_date : 20161114203101 payment_time : 213228 payment_date : 20161114 response_code : 00 payment_certificate : e75c7c018e93 authorisation_id : 526759 currency_code : 978 card_number : 5136.81 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.migneaux06 order_id : 15877 customer_email : n.migneaux06@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 = "15880" select * from cms_frontusers where identifiant = "n.migneaux06" 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 = "15880" select * from cotisations where identifiant = "a.theroude02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213707 payment_means : MASTERCARD transmission_date : 20161114203707 payment_time : 213808 payment_date : 20161114 response_code : 00 payment_certificate : c17617ee7daf authorisation_id : 231592 currency_code : 978 card_number : 5131.69 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.migneaux06 order_id : 15880 customer_email : n.migneaux06@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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15882" select * from cms_frontusers where identifiant = "je.leguyader30" 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 = "15882" select * from cotisations where identifiant = "je.leguyader30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213721 payment_means : MASTERCARD transmission_date : 20161114203721 payment_time : 213824 payment_date : 20161114 response_code : 00 payment_certificate : c33649ee7925 authorisation_id : 162322 currency_code : 978 card_number : 5131.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 : je.leguyader30 order_id : 15882 customer_email : je.leguyader30@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 = "15881" select * from cms_frontusers where identifiant = "x.morvan14" 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 = "15881" select * from cotisations where identifiant = "x.morvan14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213731 payment_means : MASTERCARD transmission_date : 20161114203731 payment_time : 213944 payment_date : 20161114 response_code : 00 payment_certificate : 8cd916517b84 authorisation_id : 143895 currency_code : 978 card_number : 5131.97 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.morvan14 order_id : 15881 customer_email : x.morvan14@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 20000 transaction_id : 214611 payment_means : MASTERCARD transmission_date : 20161114204611 payment_time : 215011 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.00 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 : p.cossard17 order_id : 15883 customer_email : p.cossard17@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15884" select * from cms_frontusers where identifiant = "m.caillard14" 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 = "15884" select * from cotisations where identifiant = "m.caillard14" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "15885" select * from cms_frontusers where identifiant = "m.mombazet10" 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 = "15885" select * from cotisations where identifiant = "m.mombazet10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215033 payment_means : MASTERCARD transmission_date : 20161114205033 payment_time : 215200 payment_date : 20161114 response_code : 00 payment_certificate : 9668114ea5f4 authorisation_id : 031191 currency_code : 978 card_number : 5132.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 : m.caillard14 order_id : 15884 customer_email : m.caillard14@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 : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214923 payment_means : VISA transmission_date : 20161114204923 payment_time : 215235 payment_date : 20161114 response_code : 00 payment_certificate : 0e4095b39587 authorisation_id : 009701 currency_code : 978 card_number : 4659.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 : m.mombazet10 order_id : 15885 customer_email : m.mombazet10@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221320 payment_means : MASTERCARD transmission_date : 20161114211320 payment_time : 221551 payment_date : 20161114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.thirion24 order_id : 15891 customer_email : a.thirion24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15890" select * from cms_frontusers where identifiant = "f.labourier05" 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 = "15890" select * from cotisations where identifiant = "f.labourier05" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "f.labourier05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220543 payment_means : VISA transmission_date : 20161114210543 payment_time : 221732 payment_date : 20161114 response_code : 00 payment_certificate : 93862642d458 authorisation_id : 493334 currency_code : 978 card_number : 4978.25 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.labourier05 order_id : 15890 customer_email : f.labourier05@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 = "15892" select * from cms_frontusers where identifiant = "k.comteboucq25" 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 = "15892" select * from cotisations where identifiant = "k.comteboucq25" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "k.comteboucq25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222542 payment_means : VISA transmission_date : 20161114212542 payment_time : 222737 payment_date : 20161114 response_code : 00 payment_certificate : 3d456528e70f authorisation_id : 726030 currency_code : 978 card_number : 4975.01 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 : k.comteboucq25 order_id : 15892 customer_email : k.comteboucq25@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 = "15894" select * from cms_frontusers where identifiant = "q.cledes19" 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 = "15894" select * from cotisations where identifiant = "q.cledes19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223956 payment_means : VISA transmission_date : 20161114213956 payment_time : 224140 payment_date : 20161114 response_code : 00 payment_certificate : d050a7a7b5b1 authorisation_id : 952556 currency_code : 978 card_number : 4978.24 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 : q.cledes19 order_id : 15894 customer_email : q.cledes19@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 = "15895" select * from cms_frontusers where identifiant = "a.cubertefond19" 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 = "15895" select * from cotisations where identifiant = "a.cubertefond19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225341 payment_means : MASTERCARD transmission_date : 20161114215341 payment_time : 225508 payment_date : 20161114 response_code : 00 payment_certificate : 83bf1ad714cb authorisation_id : 702071 currency_code : 978 card_number : 5136.29 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.cubertefond19 order_id : 15895 customer_email : a.cubertefond19@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 = "15896" select * from cms_frontusers where identifiant = "c.freydfoucault23" 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 = "15896" select * from cotisations where identifiant = "c.freydfoucault23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 234241 payment_means : MASTERCARD transmission_date : 20161114224241 payment_time : 234523 payment_date : 20161114 response_code : 00 payment_certificate : 7cfa028b7d40 authorisation_id : 467175 currency_code : 978 card_number : 5134.80 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.freydfoucault23 order_id : 15896 customer_email : c.freydfoucault23@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------