select * from cotisations_commande where id = "19225" select * from cms_frontusers where identifiant = "p.sorant26" 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 = "19225" select * from cotisations where identifiant = "m.douat20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 002433 payment_means : MASTERCARD transmission_date : 20161228232433 payment_time : 002703 payment_date : 20161229 response_code : 00 payment_certificate : 02c4707314bf authorisation_id : 052134 currency_code : 978 card_number : 5137.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 : p.sorant26 order_id : 19225 customer_email : p.sorant26@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 = "19226" select * from cms_frontusers where identifiant = "c.oger28" 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 = "19226" select * from cotisations where identifiant = "c.oger28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 065512 payment_means : VISA transmission_date : 20161229055512 payment_time : 065649 payment_date : 20161229 response_code : 00 payment_certificate : efa697286659 authorisation_id : 336302 currency_code : 978 card_number : 4978.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 : c.oger28 order_id : 19226 customer_email : c.oger28@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 074041 payment_means : VISA transmission_date : 20161229064041 payment_time : 074758 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.24 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.boehler14 order_id : 19228 customer_email : m.boehler14@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 : 201802 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 : 074851 payment_means : VISA transmission_date : 20161229064851 payment_time : 075448 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.24 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.boehler14 order_id : 19228 customer_email : m.boehler14@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 : 201802 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 : 081547 payment_means : VISA transmission_date : 20161229071547 payment_time : 082104 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.24 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.boehler14 order_id : 19229 customer_email : m.boehler14@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 : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19230" select * from cms_frontusers where identifiant = "c.dhorne02" 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 = "19230" select * from cotisations where identifiant = "c.dhorne02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090014 payment_means : VISA transmission_date : 20161229080014 payment_time : 090528 payment_date : 20161229 response_code : 00 payment_certificate : 669a645c98cd authorisation_id : 143056 currency_code : 978 card_number : 4533.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 : c.dhorne02 order_id : 19230 customer_email : c.dhorne02@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 : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19232" select * from cms_frontusers where identifiant = "g.pinot19" 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 = "19232" select * from cotisations where identifiant = "c.staerck01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092117 payment_means : VISA transmission_date : 20161229082117 payment_time : 092313 payment_date : 20161229 response_code : 00 payment_certificate : de7f1aabe881 authorisation_id : 533292 currency_code : 978 card_number : 4533.88 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.pinot19 order_id : 19232 customer_email : g.pinot19@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 = "19233" select * from cms_frontusers where identifiant = "s.laurent28" 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 = "19233" select * from cotisations where identifiant = "s.laurent28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095254 payment_means : VISA transmission_date : 20161229085254 payment_time : 095519 payment_date : 20161229 response_code : 00 payment_certificate : 25151d05bf7f authorisation_id : 242649 currency_code : 978 card_number : 4970.58 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.laurent28 order_id : 19233 customer_email : s.laurent28@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 = "19234" select * from cms_frontusers where identifiant = "c.roirand30" 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 = "19234" select * from cotisations where identifiant = "c.roirand30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095858 payment_means : MASTERCARD transmission_date : 20161229085858 payment_time : 100249 payment_date : 20161229 response_code : 00 payment_certificate : ee0c7ed7c72a authorisation_id : 839742 currency_code : 978 card_number : 5131.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.roirand30 order_id : 19234 customer_email : c.roirand30@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 = "19236" select * from cms_frontusers where identifiant = "h.caprani24" 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 = "19236" select * from cotisations where identifiant = "h.caprani24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100635 payment_means : MASTERCARD transmission_date : 20161229090635 payment_time : 100925 payment_date : 20161229 response_code : 00 payment_certificate : 68d21b9322f9 authorisation_id : 156863 currency_code : 978 card_number : 5137.64 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.caprani24 order_id : 19236 customer_email : h.caprani24@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 : 102432 payment_means : VISA transmission_date : 20161229092432 payment_time : 103103 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.07 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 : j.lemartinel15 order_id : 19237 customer_email : j.lemartinel15@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 : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102830 payment_means : VISA transmission_date : 20161229092830 payment_time : 103443 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.chaleon05 order_id : 19238 customer_email : r.chaleon05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19239" select * from cms_frontusers where identifiant = "g.boutet08" 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 = "19239" select * from cotisations where identifiant = "g.boutet08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 103845 payment_means : VISA transmission_date : 20161229093845 payment_time : 103946 payment_date : 20161229 response_code : 00 payment_certificate : e977638abd1d authorisation_id : 543687 currency_code : 978 card_number : 4150.99 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.boutet08 order_id : 19239 customer_email : g.boutet08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19240" select * from cms_frontusers where identifiant = "c.rochard17" 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 = "19240" select * from cotisations where identifiant = "c.rochard17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 105716 payment_means : MASTERCARD transmission_date : 20161229095716 payment_time : 105853 payment_date : 20161229 response_code : 00 payment_certificate : bff91d16aff9 authorisation_id : 831106 currency_code : 978 card_number : 5136.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.rochard17 order_id : 19240 customer_email : c.rochard17@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 = "19241" select * from cms_frontusers where identifiant = "c.dequeker15" 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 = "19241" select * from cotisations where identifiant = "c.dequeker15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110231 payment_means : VISA transmission_date : 20161229100231 payment_time : 110356 payment_date : 20161229 response_code : 00 payment_certificate : 515e5bd84aa9 authorisation_id : 760114 currency_code : 978 card_number : 4970.66 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.dequeker15 order_id : 19241 customer_email : c.dequeker15@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 = "19242" select * from cms_frontusers where identifiant = "r.chaleon05" 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 = "19242" select * from cotisations where identifiant = "r.chaleon05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110704 payment_means : VISA transmission_date : 20161229100704 payment_time : 110911 payment_date : 20161229 response_code : 00 payment_certificate : 307a318a83b9 authorisation_id : 946046 currency_code : 978 card_number : 4978.06 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.chaleon05 order_id : 19242 customer_email : r.chaleon05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114648 payment_means : MASTERCARD transmission_date : 20161229104648 payment_time : 114759 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.62 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.hamelin21 order_id : 19243 customer_email : a.hamelin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19243" select * from cms_frontusers where identifiant = "a.hamelin21" 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 = "19243" select * from cotisations where identifiant = "a.hamelin21" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "19244" select * from cms_frontusers where identifiant = "e.krieger17" 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 = "19244" select * from cotisations where identifiant = "e.krieger17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114810 payment_means : MASTERCARD transmission_date : 20161229104810 payment_time : 114913 payment_date : 20161229 response_code : 00 payment_certificate : e26b2597904e authorisation_id : 074442 currency_code : 978 card_number : 5100.85 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.hamelin21 order_id : 19243 customer_email : a.hamelin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201808 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114822 payment_means : VISA transmission_date : 20161229104822 payment_time : 115005 payment_date : 20161229 response_code : 00 payment_certificate : 2b68ddbc1256 authorisation_id : 153572 currency_code : 978 card_number : 4973.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 : e.krieger17 order_id : 19244 customer_email : e.krieger17@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 = "19245" select * from cms_frontusers where identifiant = "m.cadorel22" 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 = "19245" select * from cotisations where identifiant = "m.cadorel22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115647 payment_means : VISA transmission_date : 20161229105647 payment_time : 115832 payment_date : 20161229 response_code : 00 payment_certificate : f2f6459697fd authorisation_id : 296537 currency_code : 978 card_number : 4974.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 : m.cadorel22 order_id : 19245 customer_email : m.cadorel22@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 : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19246" select * from cms_frontusers where identifiant = "c.hipolite18" 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 = "19246" select * from cotisations where identifiant = "c.hipolite18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120811 payment_means : MASTERCARD transmission_date : 20161229110811 payment_time : 120939 payment_date : 20161229 response_code : 00 payment_certificate : 96c91bb10b66 authorisation_id : 466949 currency_code : 978 card_number : 5131.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 : c.hipolite18 order_id : 19246 customer_email : c.hipolite18@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 = "19247" select * from cms_frontusers where identifiant = "m.bolle28" 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 = "19247" select * from cotisations where identifiant = "m.bolle28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 121411 payment_means : VISA transmission_date : 20161229111411 payment_time : 123018 payment_date : 20161229 response_code : 00 payment_certificate : 579af5d86668 authorisation_id : 029936 currency_code : 978 card_number : 4921.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 : m.bolle28 order_id : 19247 customer_email : m.bolle28@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 = "19248" select * from cms_frontusers where identifiant = "o.dhaussy21" 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 = "19248" select * from cotisations where identifiant = "o.dhaussy21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122859 payment_means : MASTERCARD transmission_date : 20161229112859 payment_time : 123101 payment_date : 20161229 response_code : 00 payment_certificate : 21881593b7da authorisation_id : 151667 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 : o.dhaussy21 order_id : 19248 customer_email : o.dhaussy21@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 = "19249" select * from cms_frontusers where identifiant = "m.boullin06" 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 = "19249" select * from cotisations where identifiant = "m.boullin06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124103 payment_means : VISA transmission_date : 20161229114103 payment_time : 124403 payment_date : 20161229 response_code : 00 payment_certificate : effecc09f8de authorisation_id : 224347 currency_code : 978 card_number : 4978.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.boullin06 order_id : 19249 customer_email : m.boullin06@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 = "19251" select * from cms_frontusers where identifiant = "c.perrin29" 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 = "19251" select * from cotisations where identifiant = "r.dulay13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133927 payment_means : MASTERCARD transmission_date : 20161229123927 payment_time : 134156 payment_date : 20161229 response_code : 00 payment_certificate : 5cd98a32776e authorisation_id : 609269 currency_code : 978 card_number : 5131.75 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.perrin29 order_id : 19251 customer_email : c.perrin29@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 = "19253" select * from cms_frontusers where identifiant = "m.charlier26" 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 = "19253" select * from cotisations where identifiant = "m.charlier26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134200 payment_means : MASTERCARD transmission_date : 20161229124200 payment_time : 134843 payment_date : 20161229 response_code : 00 payment_certificate : 02333720c874 authorisation_id : 321024 currency_code : 978 card_number : 5131.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.charlier26 order_id : 19253 customer_email : m.charlier26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19254" select * from cms_frontusers where identifiant = "j.vuidel10" 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 = "19254" select * from cotisations where identifiant = "j.vuidel10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135026 payment_means : MASTERCARD transmission_date : 20161229125026 payment_time : 135130 payment_date : 20161229 response_code : 00 payment_certificate : 603e7c6c981a authorisation_id : 668510 currency_code : 978 card_number : 5131.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 : j.vuidel10 order_id : 19254 customer_email : j.vuidel10@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 = "19255" select * from cms_frontusers where identifiant = "t.bellest21" 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 = "19255" select * from cotisations where identifiant = "t.bellest21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140045 payment_means : VISA transmission_date : 20161229130045 payment_time : 140208 payment_date : 20161229 response_code : 00 payment_certificate : a4d60f4d5e2d authorisation_id : 341316 currency_code : 978 card_number : 4971.75 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.bellest21 order_id : 19255 customer_email : t.bellest21@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 = "19256" select * from cms_frontusers where identifiant = "m.lebon16" 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 = "19256" select * from cotisations where identifiant = "m.lebon16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 141514 payment_means : MASTERCARD transmission_date : 20161229131514 payment_time : 142025 payment_date : 20161229 response_code : 00 payment_certificate : fa1e294d4242 authorisation_id : 445743 currency_code : 978 card_number : 5131.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.lebon16 order_id : 19256 customer_email : m.lebon16@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 : 142310 payment_means : MASTERCARD transmission_date : 20161229132310 payment_time : 142437 payment_date : 20161229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 61 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.laot06 order_id : 19258 customer_email : a.laot06@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 : 142319 payment_means : MASTERCARD transmission_date : 20161229132319 payment_time : 142822 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5130.50 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.perrin29 order_id : 19259 customer_email : c.perrin29@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 : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19260" select * from cms_frontusers where identifiant = "r.guerin03" 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 = "19260" select * from cotisations where identifiant = "r.guerin03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143301 payment_means : VISA transmission_date : 20161229133301 payment_time : 143611 payment_date : 20161229 response_code : 00 payment_certificate : 355ecd6114fe authorisation_id : 484145 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 : r.guerin03 order_id : 19260 customer_email : r.guerin03@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 144048 payment_means : MASTERCARD transmission_date : 20161229134048 payment_time : 144134 payment_date : 20161229 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5304.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.obajdin16 order_id : 19261 customer_email : d.obajdin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 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 : 8000 transaction_id : 154821 payment_means : VISA transmission_date : 20161229144821 payment_time : 155008 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.dikoune15 order_id : 19262 customer_email : a.dikoune15@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 : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19262" select * from cms_frontusers where identifiant = "a.dikoune15" 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 = "19262" select * from cotisations where identifiant = "a.dikoune15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155028 payment_means : VISA transmission_date : 20161229145028 payment_time : 155201 payment_date : 20161229 response_code : 00 payment_certificate : 81bc2e5bc4d1 authorisation_id : 464701 currency_code : 978 card_number : 4978.50 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.dikoune15 order_id : 19262 customer_email : a.dikoune15@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 = "19263" select * from cms_frontusers where identifiant = "p.rebillard03" 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 = "19263" select * from cotisations where identifiant = "p.rebillard03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154946 payment_means : VISA transmission_date : 20161229144946 payment_time : 155208 payment_date : 20161229 response_code : 00 payment_certificate : 7534af08732e authorisation_id : 246776 currency_code : 978 card_number : 4975.02 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.rebillard03 order_id : 19263 customer_email : p.rebillard03@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 = "19265" select * from cms_frontusers where identifiant = "y.josse16" 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 = "19265" select * from cotisations where identifiant = "y.josse16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155308 payment_means : MASTERCARD transmission_date : 20161229145308 payment_time : 155614 payment_date : 20161229 response_code : 00 payment_certificate : b230c0ba594d authorisation_id : 511926 currency_code : 978 card_number : 5130.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.josse16 order_id : 19265 customer_email : y.josse16@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 = "19264" select * from cms_frontusers where identifiant = "c.baudoin09" 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 = "19264" select * from cotisations where identifiant = "c.baudoin09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155002 payment_means : MASTERCARD transmission_date : 20161229145002 payment_time : 155618 payment_date : 20161229 response_code : 00 payment_certificate : f98785f46d05 authorisation_id : 710223 currency_code : 978 card_number : 5131.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 : c.baudoin09 order_id : 19264 customer_email : c.baudoin09@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 = "19266" select * from cms_frontusers where identifiant = "jf.lecorre10" 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 = "19266" select * from cotisations where identifiant = "jf.lecorre10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160917 payment_means : MASTERCARD transmission_date : 20161229150917 payment_time : 161103 payment_date : 20161229 response_code : 00 payment_certificate : d3cae7e56540 authorisation_id : 256654 currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jf.lecorre10 order_id : 19266 customer_email : jf.lecorre10@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 = "19267" select * from cms_frontusers where identifiant = "jf.lecorre10" 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 = "19267" select * from cotisations where identifiant = "a.romer01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161336 payment_means : MASTERCARD transmission_date : 20161229151336 payment_time : 161518 payment_date : 20161229 response_code : 00 payment_certificate : eac053dfa252 authorisation_id : 531550 currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jf.lecorre10 order_id : 19267 customer_email : jf.lecorre10@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 = "19269" select * from cms_frontusers where identifiant = "jf.lecorre10" 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 = "19269" select * from cotisations where identifiant = "m.lecorre06" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "m.lecorre06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161817 payment_means : MASTERCARD transmission_date : 20161229151817 payment_time : 162003 payment_date : 20161229 response_code : 00 payment_certificate : 66b711bccdbe authorisation_id : 131636 currency_code : 978 card_number : 5137.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jf.lecorre10 order_id : 19269 customer_email : jf.lecorre10@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 = "19268" select * from cms_frontusers where identifiant = "l.belin01" 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 = "19268" select * from cotisations where identifiant = "l.belin01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161630 payment_means : VISA transmission_date : 20161229151630 payment_time : 162026 payment_date : 20161229 response_code : 00 payment_certificate : b340962d97d3 authorisation_id : 752242 currency_code : 978 card_number : 4976.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 : l.belin01 order_id : 19268 customer_email : l.belin01@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 = "19270" select * from cms_frontusers where identifiant = "b.haffreingue27" 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 = "19270" select * from cotisations where identifiant = "b.haffreingue27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162846 payment_means : MASTERCARD transmission_date : 20161229152846 payment_time : 163110 payment_date : 20161229 response_code : 00 payment_certificate : affd3561cb2e authorisation_id : 266231 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 : b.haffreingue27 order_id : 19270 customer_email : b.haffreingue27@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163841 payment_means : MASTERCARD transmission_date : 20161229153841 payment_time : 164039 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.35 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 : v.bernard03 order_id : 19271 customer_email : v.bernard03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19272" select * from cms_frontusers where identifiant = "f.felgines20" 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 = "19272" select * from cotisations where identifiant = "f.felgines20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165401 payment_means : MASTERCARD transmission_date : 20161229155401 payment_time : 165620 payment_date : 20161229 response_code : 00 payment_certificate : a81559aa1021 authorisation_id : 833444 currency_code : 978 card_number : 5137.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.felgines20 order_id : 19272 customer_email : f.felgines20@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 = "19273" select * from cms_frontusers where identifiant = "jm.degabriel25" 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 = "19273" select * from cotisations where identifiant = "jm.degabriel25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170116 payment_means : MASTERCARD transmission_date : 20161229160116 payment_time : 171001 payment_date : 20161229 response_code : 00 payment_certificate : 66527d1222cf authorisation_id : 432244 currency_code : 978 card_number : 5131.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.degabriel25 order_id : 19273 customer_email : jm.degabriel25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19275" select * from cms_frontusers where identifiant = "n.leblanc04" 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 = "19275" select * from cotisations where identifiant = "n.leblanc04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173739 payment_means : VISA transmission_date : 20161229163739 payment_time : 173944 payment_date : 20161229 response_code : 00 payment_certificate : 8bebe3542786 authorisation_id : 213576 currency_code : 978 card_number : 4970.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.leblanc04 order_id : 19275 customer_email : n.leblanc04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19278" select * from cms_frontusers where identifiant = "b.galichet25" 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 = "19278" select * from cotisations where identifiant = "d.brard29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181616 payment_means : VISA transmission_date : 20161229171616 payment_time : 181732 payment_date : 20161229 response_code : 00 payment_certificate : 0940cfa28e27 authorisation_id : 314325 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 : b.galichet25 order_id : 19278 customer_email : b.galichet25@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 : 181547 payment_means : MASTERCARD transmission_date : 20161229171547 payment_time : 182045 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.44 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 : j.pommier25 order_id : 19277 customer_email : j.pommier25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19280" select * from cms_frontusers where identifiant = "p.vouillon20" 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 = "19280" select * from cotisations where identifiant = "d.berite28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182113 payment_means : VISA transmission_date : 20161229172113 payment_time : 182239 payment_date : 20161229 response_code : 00 payment_certificate : 452654e7c1c2 authorisation_id : 474812 currency_code : 978 card_number : 4970.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 : p.vouillon20 order_id : 19280 customer_email : p.vouillon20@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182134 payment_means : MASTERCARD transmission_date : 20161229172134 payment_time : 182348 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.44 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 : j.pommier25 order_id : 19277 customer_email : j.pommier25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19281" select * from cms_frontusers where identifiant = "p.charpentier13" 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 = "19281" select * from cotisations where identifiant = "p.charpentier13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182349 payment_means : VISA transmission_date : 20161229172349 payment_time : 182607 payment_date : 20161229 response_code : 00 payment_certificate : 449a1cc34895 authorisation_id : 335178 currency_code : 978 card_number : 4563.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 : p.charpentier13 order_id : 19281 customer_email : p.charpentier13@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 = "19282" select * from cms_frontusers where identifiant = "t.bouteloup06" 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 = "19282" select * from cotisations where identifiant = "t.bouteloup06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183934 payment_means : VISA transmission_date : 20161229173934 payment_time : 184104 payment_date : 20161229 response_code : 00 payment_certificate : a974886c4205 authorisation_id : 429922 currency_code : 978 card_number : 4970.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.bouteloup06 order_id : 19282 customer_email : t.bouteloup06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19283" select * from cms_frontusers where identifiant = "g.houlet01" 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 = "19283" select * from cotisations where identifiant = "j.antoulin20" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "d.loustau13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 184012 payment_means : VISA transmission_date : 20161229174012 payment_time : 184124 payment_date : 20161229 response_code : 00 payment_certificate : 5427c3b86fc2 authorisation_id : 114392 currency_code : 978 card_number : 4973.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.houlet01 order_id : 19283 customer_email : g.houlet01@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 : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19285" select * from cms_frontusers where identifiant = "g.vanwalleghem30" 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 = "19285" select * from cotisations where identifiant = "g.vanwalleghem30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184520 payment_means : VISA transmission_date : 20161229174520 payment_time : 184744 payment_date : 20161229 response_code : 00 payment_certificate : 95a382f2f421 authorisation_id : 142190 currency_code : 978 card_number : 4978.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 : g.vanwalleghem30 order_id : 19285 customer_email : g.vanwalleghem30@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 = "19284" select * from cms_frontusers where identifiant = "j.leviavant10" 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 = "19284" select * from cotisations where identifiant = "j.leviavant10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184254 payment_means : VISA transmission_date : 20161229174254 payment_time : 185012 payment_date : 20161229 response_code : 00 payment_certificate : ce9994d53bf8 authorisation_id : 352652 currency_code : 978 card_number : 4973.06 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.leviavant10 order_id : 19284 customer_email : j.leviavant10@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 = "19286" select * from cms_frontusers where identifiant = "s.lafond02" 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 = "19286" select * from cotisations where identifiant = "s.lafond02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185438 payment_means : VISA transmission_date : 20161229175438 payment_time : 185705 payment_date : 20161229 response_code : 00 payment_certificate : 0e1231e6232c authorisation_id : 046514 currency_code : 978 card_number : 4976.87 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.lafond02 order_id : 19286 customer_email : s.lafond02@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 = "19287" select * from cms_frontusers where identifiant = "p.sorin21" 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 = "19287" select * from cotisations where identifiant = "p.sorin21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191017 payment_means : VISA transmission_date : 20161229181017 payment_time : 191251 payment_date : 20161229 response_code : 00 payment_certificate : b9a4f2c4deee authorisation_id : 697321 currency_code : 978 card_number : 4901.94 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.sorin21 order_id : 19287 customer_email : p.sorin21@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191524 payment_means : VISA transmission_date : 20161229181524 payment_time : 192553 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.60 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.bielec26 order_id : 19288 customer_email : c.bielec26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19288" select * from cms_frontusers where identifiant = "c.bielec26" 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 = "19288" select * from cotisations where identifiant = "c.bielec26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192556 payment_means : VISA transmission_date : 20161229182556 payment_time : 192718 payment_date : 20161229 response_code : 00 payment_certificate : ffd705acba2f authorisation_id : 950448 currency_code : 978 card_number : 4059.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 : c.bielec26 order_id : 19288 customer_email : c.bielec26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19289" select * from cms_frontusers where identifiant = "b.lamontagne18" 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 = "19289" select * from cotisations where identifiant = "b.lamontagne18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194758 payment_means : VISA transmission_date : 20161229184758 payment_time : 194918 payment_date : 20161229 response_code : 00 payment_certificate : 70e4f2519b7a authorisation_id : 316352 currency_code : 978 card_number : 4556.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 : b.lamontagne18 order_id : 19289 customer_email : b.lamontagne18@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 = "19290" select * from cms_frontusers where identifiant = "n.bonduau19" 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 = "19290" select * from cotisations where identifiant = "n.bonduau19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200633 payment_means : MASTERCARD transmission_date : 20161229190633 payment_time : 200851 payment_date : 20161229 response_code : 00 payment_certificate : eaa4f6b7e562 authorisation_id : 205427 currency_code : 978 card_number : 5131.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 : n.bonduau19 order_id : 19290 customer_email : n.bonduau19@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200810 payment_means : VISA transmission_date : 20161229190810 payment_time : 201523 payment_date : 20161229 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.22 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 : d.coulaud26 order_id : 19291 customer_email : d.coulaud26@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19294" select * from cms_frontusers where identifiant = "p.voisin09" 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 = "19294" select * from cotisations where identifiant = "p.voisin09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211724 payment_means : VISA transmission_date : 20161229201724 payment_time : 211817 payment_date : 20161229 response_code : 00 payment_certificate : df73fd5ff7e7 authorisation_id : 845575 currency_code : 978 card_number : 4972.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.voisin09 order_id : 19294 customer_email : p.voisin09@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 = "19295" select * from cms_frontusers where identifiant = "y.menard19" 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 = "19295" select * from cotisations where identifiant = "y.menard19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212346 payment_means : MASTERCARD transmission_date : 20161229202346 payment_time : 213018 payment_date : 20161229 response_code : 00 payment_certificate : 4a9dba6f0d29 authorisation_id : 233355 currency_code : 978 card_number : 5130.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.menard19 order_id : 19295 customer_email : y.menard19@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 = "19296" select * from cms_frontusers where identifiant = "d.coulaud26" 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 = "19296" select * from cotisations where identifiant = "f.sibelli01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214817 payment_means : VISA transmission_date : 20161229204817 payment_time : 215110 payment_date : 20161229 response_code : 00 payment_certificate : af924b0adcc2 authorisation_id : 522192 currency_code : 978 card_number : 4978.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.coulaud26 order_id : 19296 customer_email : d.coulaud26@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 = "19297" select * from cms_frontusers where identifiant = "g.beyel11" 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 = "19297" select * from cotisations where identifiant = "g.beyel11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220217 payment_means : VISA transmission_date : 20161229210217 payment_time : 220525 payment_date : 20161229 response_code : 00 payment_certificate : 857cb6f0a9a4 authorisation_id : 015763 currency_code : 978 card_number : 4975.05 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.beyel11 order_id : 19297 customer_email : g.beyel11@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 = "19298" select * from cms_frontusers where identifiant = "p.corbel18" 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 = "19298" select * from cotisations where identifiant = "p.corbel18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223439 payment_means : VISA transmission_date : 20161229213439 payment_time : 223729 payment_date : 20161229 response_code : 00 payment_certificate : ef920d01ac80 authorisation_id : 071273 currency_code : 978 card_number : 4974.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 : p.corbel18 order_id : 19298 customer_email : p.corbel18@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------