Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 061156 payment_means : MASTERCARD transmission_date : 20170110051156 payment_time : 061313 payment_date : 20170110 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5307.05 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 : g.petrot26 order_id : 20121 customer_email : g.petrot26@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20122" select * from cms_frontusers where identifiant = "c.dechandon09" 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 = "20122" select * from cotisations where identifiant = "c.dechandon09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071330 payment_means : MASTERCARD transmission_date : 20170110061330 payment_time : 071615 payment_date : 20170110 response_code : 00 payment_certificate : 39feb7917e2a authorisation_id : 183734 currency_code : 978 card_number : 5341.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.dechandon09 order_id : 20122 customer_email : c.dechandon09@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 : 071759 payment_means : VISA transmission_date : 20170110061759 payment_time : 072222 payment_date : 20170110 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.tollard08 order_id : 20123 customer_email : p.tollard08@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 : ------------------------------------------- select * from cotisations_commande where id = "20124" select * from cms_frontusers where identifiant = "s.sauve18" 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 = "20124" select * from cotisations where identifiant = "s.sauve18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 074248 payment_means : MASTERCARD transmission_date : 20170110064248 payment_time : 074450 payment_date : 20170110 response_code : 00 payment_certificate : 9e6a24f655b0 authorisation_id : 566715 currency_code : 978 card_number : 5132.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 : s.sauve18 order_id : 20124 customer_email : s.sauve18@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 = "20126" select * from cms_frontusers where identifiant = "s.lespinas12" 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 = "20126" select * from cotisations where identifiant = "s.lespinas12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081846 payment_means : MASTERCARD transmission_date : 20170110071846 payment_time : 082009 payment_date : 20170110 response_code : 00 payment_certificate : 6c2d3a5c087a authorisation_id : 695791 currency_code : 978 card_number : 5131.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.lespinas12 order_id : 20126 customer_email : s.lespinas12@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 = "20128" select * from cms_frontusers where identifiant = "d.venza27" 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 = "20128" select * from cotisations where identifiant = "d.venza27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092706 payment_means : VISA transmission_date : 20170110082706 payment_time : 092821 payment_date : 20170110 response_code : 00 payment_certificate : 7a3181408b1f authorisation_id : 366339 currency_code : 978 card_number : 4533.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 : d.venza27 order_id : 20128 customer_email : d.venza27@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 = "20130" select * from cms_frontusers where identifiant = "j.lecointre27" 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 = "20130" select * from cotisations where identifiant = "j.lecointre27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094912 payment_means : VISA transmission_date : 20170110084912 payment_time : 095028 payment_date : 20170110 response_code : 00 payment_certificate : d7ed5bdabccd authorisation_id : 165625 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 : j.lecointre27 order_id : 20130 customer_email : j.lecointre27@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 : 100154 payment_means : MASTERCARD transmission_date : 20170110090154 payment_time : 100357 payment_date : 20170110 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 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 : r.flachard15 order_id : 20131 customer_email : r.flachard15@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 : 8000 transaction_id : 100407 payment_means : MASTERCARD transmission_date : 20170110090407 payment_time : 100522 payment_date : 20170110 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 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 : r.flachard15 order_id : 20131 customer_email : r.flachard15@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 : 8000 transaction_id : 100545 payment_means : MASTERCARD transmission_date : 20170110090545 payment_time : 100756 payment_date : 20170110 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.66 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.flachard15 order_id : 20131 customer_email : r.flachard15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20131" select * from cms_frontusers where identifiant = "r.flachard15" 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 = "20131" select * from cotisations where identifiant = "r.flachard15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100809 payment_means : MASTERCARD transmission_date : 20170110090809 payment_time : 100935 payment_date : 20170110 response_code : 00 payment_certificate : 1e0dc8a74491 authorisation_id : 356570 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 : r.flachard15 order_id : 20131 customer_email : r.flachard15@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 = "20132" select * from cms_frontusers where identifiant = "jm.schaffner20" 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 = "20132" select * from cotisations where identifiant = "jm.schaffner20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101410 payment_means : MASTERCARD transmission_date : 20170110091410 payment_time : 101556 payment_date : 20170110 response_code : 00 payment_certificate : 9e95e6577a57 authorisation_id : 465136 currency_code : 978 card_number : 5137.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 : jm.schaffner20 order_id : 20132 customer_email : jm.schaffner20@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 = "20133" select * from cms_frontusers where identifiant = "j.dubrac14" 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 = "20133" select * from cotisations where identifiant = "j.dubrac14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101800 payment_means : VISA transmission_date : 20170110091800 payment_time : 102128 payment_date : 20170110 response_code : 00 payment_certificate : 1194c1a4dcfc authorisation_id : 763332 currency_code : 978 card_number : 4972.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 : j.dubrac14 order_id : 20133 customer_email : j.dubrac14@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 = "20134" select * from cms_frontusers where identifiant = "f.petrus14" 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 = "20134" select * from cotisations where identifiant = "f.petrus14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103837 payment_means : MASTERCARD transmission_date : 20170110093837 payment_time : 104333 payment_date : 20170110 response_code : 00 payment_certificate : c853fd303715 authorisation_id : 230346 currency_code : 978 card_number : 5137.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 : f.petrus14 order_id : 20134 customer_email : f.petrus14@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 = "20135" select * from cms_frontusers where identifiant = "n.marcilly10" 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 = "20135" select * from cotisations where identifiant = "n.marcilly10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111430 payment_means : MASTERCARD transmission_date : 20170110101430 payment_time : 111542 payment_date : 20170110 response_code : 00 payment_certificate : 2a1b49c11b35 authorisation_id : 569230 currency_code : 978 card_number : 5131.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 : n.marcilly10 order_id : 20135 customer_email : n.marcilly10@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 = "20136" select * from cms_frontusers where identifiant = "a.jacquinet07" 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 = "20136" select * from cotisations where identifiant = "a.jacquinet07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111924 payment_means : MASTERCARD transmission_date : 20170110101924 payment_time : 112437 payment_date : 20170110 response_code : 00 payment_certificate : 3487fbce6e9f authorisation_id : 382149 currency_code : 978 card_number : 5136.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 : a.jacquinet07 order_id : 20136 customer_email : a.jacquinet07@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 = "20138" select * from cms_frontusers where identifiant = "c.calliot28" 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 = "20138" select * from cotisations where identifiant = "c.calliot28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132042 payment_means : VISA transmission_date : 20170110122042 payment_time : 132312 payment_date : 20170110 response_code : 00 payment_certificate : 3e5823a99ade authorisation_id : 206732 currency_code : 978 card_number : 4975.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 : c.calliot28 order_id : 20138 customer_email : c.calliot28@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 = "20139" select * from cms_frontusers where identifiant = "jp.haudebert13" 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 = "20139" select * from cotisations where identifiant = "jp.haudebert13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142118 payment_means : VISA transmission_date : 20170110132118 payment_time : 142313 payment_date : 20170110 response_code : 00 payment_certificate : 0a10741636fb authorisation_id : 260915 currency_code : 978 card_number : 4978.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.haudebert13 order_id : 20139 customer_email : jp.haudebert13@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 = "20140" select * from cms_frontusers where identifiant = "j.desmarets08" 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 = "20140" select * from cotisations where identifiant = "j.desmarets08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151114 payment_means : MASTERCARD transmission_date : 20170110141114 payment_time : 151353 payment_date : 20170110 response_code : 00 payment_certificate : 105d44716892 authorisation_id : 636156 currency_code : 978 card_number : 5131.76 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.desmarets08 order_id : 20140 customer_email : j.desmarets08@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 = "20142" select * from cms_frontusers where identifiant = "m.guy19" 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 = "20142" select * from cotisations where identifiant = "m.guy19" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.guy19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164032 payment_means : VISA transmission_date : 20170110154032 payment_time : 164200 payment_date : 20170110 response_code : 00 payment_certificate : 7684408b81cc authorisation_id : 752562 currency_code : 978 card_number : 4978.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.guy19 order_id : 20142 customer_email : m.guy19@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 = "20143" select * from cms_frontusers where identifiant = "l.rabreau26" 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 = "20143" select * from cotisations where identifiant = "l.rabreau26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174348 payment_means : MASTERCARD transmission_date : 20170110164348 payment_time : 174532 payment_date : 20170110 response_code : 00 payment_certificate : 9a9cc87257bc authorisation_id : 830133 currency_code : 978 card_number : 5137.47 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.rabreau26 order_id : 20143 customer_email : l.rabreau26@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 = "20144" select * from cms_frontusers where identifiant = "e.tugend24" 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 = "20144" select * from cotisations where identifiant = "e.tugend24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 181409 payment_means : VISA transmission_date : 20170110171409 payment_time : 181539 payment_date : 20170110 response_code : 00 payment_certificate : 4f20e2a1e983 authorisation_id : 713932 currency_code : 978 card_number : 4978.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 : e.tugend24 order_id : 20144 customer_email : e.tugend24@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 = "20145" select * from cms_frontusers where identifiant = "d.coudert02" 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 = "20145" select * from cotisations where identifiant = "d.coudert02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181425 payment_means : VISA transmission_date : 20170110171425 payment_time : 181717 payment_date : 20170110 response_code : 00 payment_certificate : f758bdc7511a authorisation_id : 436890 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 : d.coudert02 order_id : 20145 customer_email : d.coudert02@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 = "20146" select * from cms_frontusers where identifiant = "m.thiriet28" 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 = "20146" select * from cotisations where identifiant = "m.thiriet28" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "m.thiriet28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181639 payment_means : VISA transmission_date : 20170110171639 payment_time : 181817 payment_date : 20170110 response_code : 00 payment_certificate : 6ce46fbdaf33 authorisation_id : 561284 currency_code : 978 card_number : 4978.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 : m.thiriet28 order_id : 20146 customer_email : m.thiriet28@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 : 182614 payment_means : VISA transmission_date : 20170110172614 payment_time : 182948 payment_date : 20170110 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.50 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.grosselin25 order_id : 20148 customer_email : c.grosselin25@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 = "20149" select * from cms_frontusers where identifiant = "a.fischer01" 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 = "20149" select * from cotisations where identifiant = "a.fischer01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184802 payment_means : MASTERCARD transmission_date : 20170110174802 payment_time : 184907 payment_date : 20170110 response_code : 00 payment_certificate : fd3fa5bce0a0 authorisation_id : 011513 currency_code : 978 card_number : 5131.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 : a.fischer01 order_id : 20149 customer_email : a.fischer01@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 = "20150" select * from cms_frontusers where identifiant = "l.waliszewski20" 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 = "20150" select * from cotisations where identifiant = "a.lecuziat17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185518 payment_means : VISA transmission_date : 20170110175518 payment_time : 185802 payment_date : 20170110 response_code : 00 payment_certificate : 77a6d747fda2 authorisation_id : 425655 currency_code : 978 card_number : 4978.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 : l.waliszewski20 order_id : 20150 customer_email : l.waliszewski20@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 = "20151" select * from cms_frontusers where identifiant = "o.lesne24" 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 = "20151" select * from cotisations where identifiant = "o.lesne24" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "o.lesne24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185652 payment_means : MASTERCARD transmission_date : 20170110175652 payment_time : 190018 payment_date : 20170110 response_code : 00 payment_certificate : cfd427f9d3c5 authorisation_id : 525704 currency_code : 978 card_number : 5131.89 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.lesne24 order_id : 20151 customer_email : o.lesne24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191215 payment_means : MASTERCARD transmission_date : 20170110181215 payment_time : 191343 payment_date : 20170110 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.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 : q.tristant19 order_id : 20152 customer_email : q.tristant19@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191350 payment_means : VISA transmission_date : 20170110181350 payment_time : 191506 payment_date : 20170110 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5431.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 : q.tristant19 order_id : 20152 customer_email : q.tristant19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20152" select * from cms_frontusers where identifiant = "q.tristant19" 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 = "20152" select * from cotisations where identifiant = "jm.thiebault03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191511 payment_means : MASTERCARD transmission_date : 20170110181511 payment_time : 191627 payment_date : 20170110 response_code : 00 payment_certificate : 6349bfe3eac3 authorisation_id : 117405 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 : q.tristant19 order_id : 20152 customer_email : q.tristant19@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 = "20153" select * from cms_frontusers where identifiant = "j.guesset20" 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 = "20153" select * from cotisations where identifiant = "j.guesset20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191728 payment_means : VISA transmission_date : 20170110181728 payment_time : 192257 payment_date : 20170110 response_code : 00 payment_certificate : 5d04797bf130 authorisation_id : 135614 currency_code : 978 card_number : 4975.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 : j.guesset20 order_id : 20153 customer_email : j.guesset20@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 = "20154" select * from cms_frontusers where identifiant = "m.lembert31" 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 = "20154" select * from cotisations where identifiant = "m.lembert31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192831 payment_means : VISA transmission_date : 20170110182831 payment_time : 192942 payment_date : 20170110 response_code : 00 payment_certificate : 0a1dd23aabcd authorisation_id : 561524 currency_code : 978 card_number : 4533.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.lembert31 order_id : 20154 customer_email : m.lembert31@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 = "20155" select * from cms_frontusers where identifiant = "r.genty11" 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 = "20155" select * from cotisations where identifiant = "r.genty11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194557 payment_means : VISA transmission_date : 20170110184557 payment_time : 194909 payment_date : 20170110 response_code : 00 payment_certificate : 11b62a657a57 authorisation_id : 648159 currency_code : 978 card_number : 4978.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.genty11 order_id : 20155 customer_email : r.genty11@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 : ------------------------------------------- select * from cotisations_commande where id = "20156" select * from cms_frontusers where identifiant = "f.cordier02" 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 = "20156" select * from cotisations where identifiant = "f.martin04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195249 payment_means : MASTERCARD transmission_date : 20170110185249 payment_time : 195528 payment_date : 20170110 response_code : 00 payment_certificate : a7cf889e1bed authorisation_id : 661603 currency_code : 978 card_number : 5137.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 : f.cordier02 order_id : 20156 customer_email : f.cordier02@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 = "20157" select * from cms_frontusers where identifiant = "jp.seurin20" 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 = "20157" select * from cotisations where identifiant = "jp.seurin20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200802 payment_means : MASTERCARD transmission_date : 20170110190802 payment_time : 200947 payment_date : 20170110 response_code : 00 payment_certificate : 4f60d40cee27 authorisation_id : 311863 currency_code : 978 card_number : 5134.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 : jp.seurin20 order_id : 20157 customer_email : jp.seurin20@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 = "20158" select * from cms_frontusers where identifiant = "d.chapeland23" 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 = "20158" select * from cotisations where identifiant = "d.chapeland23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201205 payment_means : VISA transmission_date : 20170110191205 payment_time : 201805 payment_date : 20170110 response_code : 00 payment_certificate : 077d61a6e0db authorisation_id : 696242 currency_code : 978 card_number : 4978.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.chapeland23 order_id : 20158 customer_email : d.chapeland23@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 = "20162" select * from cms_frontusers where identifiant = "t.piva11" 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 = "20162" select * from cotisations where identifiant = "t.piva11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201752 payment_means : VISA transmission_date : 20170110191752 payment_time : 201944 payment_date : 20170110 response_code : 00 payment_certificate : c48537a236e4 authorisation_id : 119462 currency_code : 978 card_number : 4978.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 : t.piva11 order_id : 20162 customer_email : t.piva11@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 = "20163" select * from cms_frontusers where identifiant = "g.petrot26" 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 = "20163" select * from cotisations where identifiant = "g.petrot26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201958 payment_means : MASTERCARD transmission_date : 20170110191958 payment_time : 202705 payment_date : 20170110 response_code : 00 payment_certificate : 44832adb2a9b authorisation_id : 496078 currency_code : 978 card_number : 5307.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.petrot26 order_id : 20163 customer_email : g.petrot26@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 : ------------------------------------------- select * from cotisations_commande where id = "20164" select * from cms_frontusers where identifiant = "r.grazia05" 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 = "20164" select * from cotisations where identifiant = "r.grazia05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202633 payment_means : MASTERCARD transmission_date : 20170110192633 payment_time : 202941 payment_date : 20170110 response_code : 00 payment_certificate : 6d3d5d2da501 authorisation_id : 257953 currency_code : 978 card_number : 5130.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 : r.grazia05 order_id : 20164 customer_email : r.grazia05@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 = "20168" select * from cms_frontusers where identifiant = "p.bonhomme19" 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 = "20168" select * from cotisations where identifiant = "p.bonhomme19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204024 payment_means : MASTERCARD transmission_date : 20170110194024 payment_time : 204209 payment_date : 20170110 response_code : 00 payment_certificate : 9be63a5db2fa authorisation_id : 717521 currency_code : 978 card_number : 5817.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.bonhomme19 order_id : 20168 customer_email : p.bonhomme19@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 = "20170" select * from cms_frontusers where identifiant = "b.billioud05" 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 = "20170" select * from cotisations where identifiant = "b.billioud05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205238 payment_means : MASTERCARD transmission_date : 20170110195238 payment_time : 205411 payment_date : 20170110 response_code : 00 payment_certificate : d34debfde03a authorisation_id : 513132 currency_code : 978 card_number : 5131.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.billioud05 order_id : 20170 customer_email : b.billioud05@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 = "20171" select * from cms_frontusers where identifiant = "p.bernut23" 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 = "20171" select * from cotisations where identifiant = "c.bauge06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210008 payment_means : VISA transmission_date : 20170110200008 payment_time : 210121 payment_date : 20170110 response_code : 00 payment_certificate : feeeaa8e6dbb authorisation_id : 702062 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 : p.bernut23 order_id : 20171 customer_email : p.bernut23@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 = "20172" select * from cms_frontusers where identifiant = "m.cornet15" 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 = "20172" select * from cotisations where identifiant = "m.cornet15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210359 payment_means : VISA transmission_date : 20170110200359 payment_time : 210458 payment_date : 20170110 response_code : 00 payment_certificate : b30dd2ae71f9 authorisation_id : 451767 currency_code : 978 card_number : 4970.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 : m.cornet15 order_id : 20172 customer_email : m.cornet15@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 = "20173" select * from cms_frontusers where identifiant = "b.michet06" 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 = "20173" select * from cotisations where identifiant = "b.michet06" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "p.ferreolragotin01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 213434 payment_means : MASTERCARD transmission_date : 20170110203434 payment_time : 213637 payment_date : 20170110 response_code : 00 payment_certificate : 1692dbb8dbae authorisation_id : 643532 currency_code : 978 card_number : 5136.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 : b.michet06 order_id : 20173 customer_email : b.michet06@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 : 4000 transaction_id : 205239 payment_means : MASTERCARD transmission_date : 20170110195239 payment_time : 220031 payment_date : 20170110 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.33 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 : j.archambaud05 order_id : 20169 customer_email : j.archambaud05@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 = "20174" select * from cms_frontusers where identifiant = "j.archambaud05" 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 = "20174" select * from cotisations where identifiant = "j.archambaud05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220135 payment_means : MASTERCARD transmission_date : 20170110210135 payment_time : 220425 payment_date : 20170110 response_code : 00 payment_certificate : ddf196ac0ddb authorisation_id : 223251 currency_code : 978 card_number : 5131.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 : j.archambaud05 order_id : 20174 customer_email : j.archambaud05@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 = "20176" select * from cms_frontusers where identifiant = "r.piau19" 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 = "20176" select * from cotisations where identifiant = "g.treille02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220933 payment_means : VISA transmission_date : 20170110210933 payment_time : 221059 payment_date : 20170110 response_code : 00 payment_certificate : af887ca409bf authorisation_id : 619959 currency_code : 978 card_number : 4970.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.piau19 order_id : 20176 customer_email : r.piau19@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 = "20175" select * from cms_frontusers where identifiant = "s.ruck18" 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 = "20175" select * from cotisations where identifiant = "s.ruck18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220834 payment_means : VISA transmission_date : 20170110210834 payment_time : 221152 payment_date : 20170110 response_code : 00 payment_certificate : c572e428bf59 authorisation_id : 239518 currency_code : 978 card_number : 4978.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 : s.ruck18 order_id : 20175 customer_email : s.ruck18@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 = "20178" select * from cms_frontusers where identifiant = "m.querin25" 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 = "20178" select * from cotisations where identifiant = "m.querin25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222922 payment_means : MASTERCARD transmission_date : 20170110212922 payment_time : 223040 payment_date : 20170110 response_code : 00 payment_certificate : 977e654015ff authorisation_id : 833952 currency_code : 978 card_number : 5132.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 : m.querin25 order_id : 20178 customer_email : m.querin25@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 : -------------------------------------------