Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 043958 payment_means : VISA transmission_date : 20161214033958 payment_time : 044207 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4530.11 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 : jb.gil08 order_id : 18260 customer_email : jb.gil08@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 : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18261" select * from cms_frontusers where identifiant = "d.dominguez16" 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 = "18261" select * from cotisations where identifiant = "d.dominguez16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 063349 payment_means : VISA transmission_date : 20161214053349 payment_time : 063547 payment_date : 20161214 response_code : 00 payment_certificate : e351a090d979 authorisation_id : 443453 currency_code : 978 card_number : 4972.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 : d.dominguez16 order_id : 18261 customer_email : d.dominguez16@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 = "18078" select * from cms_frontusers where identifiant = "a.killian23" 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 = "18078" select * from cotisations where identifiant = "a.killian23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 123521 payment_means : VISA transmission_date : 20161212113521 payment_time : 075032 payment_date : 20161214 response_code : 00 payment_certificate : d556227dec5d authorisation_id : 703935 currency_code : 978 card_number : 4974.69 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.killian23 order_id : 18078 customer_email : a.killian23@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 = "18262" select * from cms_frontusers where identifiant = "b.visse10" 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 = "18262" select * from cotisations where identifiant = "l.gourdon21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081232 payment_means : MASTERCARD transmission_date : 20161214071232 payment_time : 081501 payment_date : 20161214 response_code : 00 payment_certificate : c6dc339bfe43 authorisation_id : 432633 currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.visse10 order_id : 18262 customer_email : b.visse10@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 = "18263" select * from cms_frontusers where identifiant = "jj.colle30" 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 = "18263" select * from cotisations where identifiant = "jj.colle30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084316 payment_means : VISA transmission_date : 20161214074316 payment_time : 084458 payment_date : 20161214 response_code : 00 payment_certificate : a0260e3b8b11 authorisation_id : 202105 currency_code : 978 card_number : 4974.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 : jj.colle30 order_id : 18263 customer_email : jj.colle30@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 = "18264" select * from cms_frontusers where identifiant = "g.kieffer20" 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 = "18264" select * from cotisations where identifiant = "g.kieffer20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085323 payment_means : MASTERCARD transmission_date : 20161214075323 payment_time : 085528 payment_date : 20161214 response_code : 00 payment_certificate : 568d4f670960 authorisation_id : 534526 currency_code : 978 card_number : 5131.73 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.kieffer20 order_id : 18264 customer_email : g.kieffer20@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 = "18265" select * from cms_frontusers where identifiant = "c.michon05" 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 = "18265" select * from cotisations where identifiant = "c.michon05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085905 payment_means : MASTERCARD transmission_date : 20161214075905 payment_time : 090003 payment_date : 20161214 response_code : 00 payment_certificate : a270b57f33d3 authorisation_id : 592506 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 : c.michon05 order_id : 18265 customer_email : c.michon05@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 = "18266" select * from cms_frontusers where identifiant = "r.desa05" 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 = "18266" select * from cotisations where identifiant = "t.raffault07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090617 payment_means : VISA transmission_date : 20161214080617 payment_time : 090826 payment_date : 20161214 response_code : 00 payment_certificate : 6c0bb321dccd authorisation_id : 825639 currency_code : 978 card_number : 4975.15 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.desa05 order_id : 18266 customer_email : r.desa05@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 = "18268" select * from cms_frontusers where identifiant = "js.pommepuy26" 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 = "18268" select * from cotisations where identifiant = "js.pommepuy26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092054 payment_means : VISA transmission_date : 20161214082054 payment_time : 092344 payment_date : 20161214 response_code : 00 payment_certificate : cc9dca44fdd0 authorisation_id : 039781 currency_code : 978 card_number : 4975.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : js.pommepuy26 order_id : 18268 customer_email : js.pommepuy26@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 : 095637 payment_means : VISA transmission_date : 20161214085637 payment_time : 095812 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.houdayer20 order_id : 18269 customer_email : s.houdayer20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18269" select * from cms_frontusers where identifiant = "s.houdayer20" 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 = "18269" select * from cotisations where identifiant = "s.houdayer20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095837 payment_means : VISA transmission_date : 20161214085837 payment_time : 100035 payment_date : 20161214 response_code : 00 payment_certificate : eefc1b74d62c authorisation_id : 115670 currency_code : 978 card_number : 4977.95 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.houdayer20 order_id : 18269 customer_email : s.houdayer20@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 = "18271" select * from cms_frontusers where identifiant = "m.claus16" 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 = "18271" select * from cotisations where identifiant = "c.oger07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101210 payment_means : MASTERCARD transmission_date : 20161214091210 payment_time : 101331 payment_date : 20161214 response_code : 00 payment_certificate : 7b8354f2f398 authorisation_id : 604592 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.claus16 order_id : 18271 customer_email : m.claus16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18273" select * from cms_frontusers where identifiant = "p.ruscassie14" 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 = "18273" select * from cotisations where identifiant = "p.ruscassie14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103812 payment_means : VISA transmission_date : 20161214093812 payment_time : 104326 payment_date : 20161214 response_code : 00 payment_certificate : 6188eb12a494 authorisation_id : 961774 currency_code : 978 card_number : 4973.79 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.ruscassie14 order_id : 18273 customer_email : p.ruscassie14@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 = "18274" select * from cms_frontusers where identifiant = "s.meyer11" 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 = "18274" select * from cotisations where identifiant = "s.meyer11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111022 payment_means : VISA transmission_date : 20161214101022 payment_time : 111225 payment_date : 20161214 response_code : 00 payment_certificate : efd9e7edaad3 authorisation_id : 924340 currency_code : 978 card_number : 4975.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 : s.meyer11 order_id : 18274 customer_email : s.meyer11@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 = "18276" select * from cms_frontusers where identifiant = "g.estarague08" 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 = "18276" select * from cotisations where identifiant = "g.estarague08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115033 payment_means : VISA transmission_date : 20161214105033 payment_time : 115221 payment_date : 20161214 response_code : 00 payment_certificate : 3f3d45d1f214 authorisation_id : 463356 currency_code : 978 card_number : 4970.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 : g.estarague08 order_id : 18276 customer_email : g.estarague08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18277" 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 = "18277" select * from cotisations where identifiant = "b.fourmont05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124223 payment_means : VISA transmission_date : 20161214114223 payment_time : 124403 payment_date : 20161214 response_code : 00 payment_certificate : 25cb4c9febfd authorisation_id : 548421 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 : q.tristant19 order_id : 18277 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 = "18278" select * from cms_frontusers where identifiant = "a.gourdon27" 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 = "18278" select * from cotisations where identifiant = "a.gourdon27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124739 payment_means : MASTERCARD transmission_date : 20161214114739 payment_time : 125211 payment_date : 20161214 response_code : 00 payment_certificate : f4ecc7d36ce2 authorisation_id : 159632 currency_code : 978 card_number : 5131.63 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.gourdon27 order_id : 18278 customer_email : a.gourdon27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18279" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "18279" select * from cotisations where identifiant = "p.brana26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131951 payment_means : VISA transmission_date : 20161214121951 payment_time : 132120 payment_date : 20161214 response_code : 00 payment_certificate : f06445f2acc6 authorisation_id : 229162 currency_code : 978 card_number : 4059.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.cordier16 order_id : 18279 customer_email : d.cordier16@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 = "18280" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "18280" select * from cotisations where identifiant = "j.degirolamo14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133249 payment_means : VISA transmission_date : 20161214123249 payment_time : 133424 payment_date : 20161214 response_code : 00 payment_certificate : 8e1ed4946b6a authorisation_id : 249221 currency_code : 978 card_number : 4059.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 : d.cordier16 order_id : 18280 customer_email : d.cordier16@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 = "18281" select * from cms_frontusers where identifiant = "g.doron16" 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 = "18281" select * from cotisations where identifiant = "g.doron16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133252 payment_means : MASTERCARD transmission_date : 20161214123252 payment_time : 133443 payment_date : 20161214 response_code : 00 payment_certificate : c103191c1579 authorisation_id : 946506 currency_code : 978 card_number : 5131.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 : g.doron16 order_id : 18281 customer_email : g.doron16@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 = "18283" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "18283" select * from cotisations where identifiant = "d.grippon09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133543 payment_means : VISA transmission_date : 20161214123543 payment_time : 133707 payment_date : 20161214 response_code : 00 payment_certificate : ec96e4e6b3a5 authorisation_id : 134952 currency_code : 978 card_number : 4059.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.cordier16 order_id : 18283 customer_email : d.cordier16@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 = "18282" select * from cms_frontusers where identifiant = "j.andrestonetto30" 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 = "18282" select * from cotisations where identifiant = "j.andrestonetto30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133337 payment_means : MASTERCARD transmission_date : 20161214123337 payment_time : 133726 payment_date : 20161214 response_code : 00 payment_certificate : f89685f6c42c authorisation_id : 504134 currency_code : 978 card_number : 5131.95 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.andrestonetto30 order_id : 18282 customer_email : j.andrestonetto30@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 = "18285" select * from cms_frontusers where identifiant = "d.cordier16" 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 = "18285" select * from cotisations where identifiant = "p.barege27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133833 payment_means : VISA transmission_date : 20161214123833 payment_time : 133948 payment_date : 20161214 response_code : 00 payment_certificate : 819eb9ae7b95 authorisation_id : 129137 currency_code : 978 card_number : 4059.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 : d.cordier16 order_id : 18285 customer_email : d.cordier16@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 = "18284" select * from cms_frontusers where identifiant = "g.doron16" 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 = "18284" select * from cotisations where identifiant = "n.leforestierdequi14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 133755 payment_means : MASTERCARD transmission_date : 20161214123755 payment_time : 133958 payment_date : 20161214 response_code : 00 payment_certificate : 8dfd86b6df06 authorisation_id : 724643 currency_code : 978 card_number : 5131.15 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.doron16 order_id : 18284 customer_email : g.doron16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18288" select * from cms_frontusers where identifiant = "c.scherrer28" 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 = "18288" select * from cotisations where identifiant = "c.scherrer28" 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 : 20161214132118 payment_time : 142308 payment_date : 20161214 response_code : 00 payment_certificate : 59fd13adad9b authorisation_id : 656209 currency_code : 978 card_number : 4975.77 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.scherrer28 order_id : 18288 customer_email : c.scherrer28@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 = "18289" select * from cms_frontusers where identifiant = "y.atif04" 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 = "18289" select * from cotisations where identifiant = "y.atif04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 153545 payment_means : VISA transmission_date : 20161214143545 payment_time : 153653 payment_date : 20161214 response_code : 00 payment_certificate : 109e7e1b916f authorisation_id : 443654 currency_code : 978 card_number : 4978.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.atif04 order_id : 18289 customer_email : y.atif04@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 = "18290" select * from cms_frontusers where identifiant = "y.poncato27" 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 = "18290" select * from cotisations where identifiant = "y.poncato27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155219 payment_means : VISA transmission_date : 20161214145219 payment_time : 155806 payment_date : 20161214 response_code : 00 payment_certificate : f2ff02f1375b authorisation_id : 184523 currency_code : 978 card_number : 4975.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.poncato27 order_id : 18290 customer_email : y.poncato27@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 = "18292" select * from cms_frontusers where identifiant = "f.poirier09" 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 = "18292" select * from cotisations where identifiant = "f.poirier09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160536 payment_means : VISA transmission_date : 20161214150536 payment_time : 160829 payment_date : 20161214 response_code : 00 payment_certificate : 277f0f00d7fd authorisation_id : 510926 currency_code : 978 card_number : 4975.31 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.poirier09 order_id : 18292 customer_email : f.poirier09@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 : 160455 payment_means : VISA transmission_date : 20161214150455 payment_time : 160916 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.36 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.lannou28 order_id : 18291 customer_email : c.lannou28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18294" select * from cms_frontusers where identifiant = "m.bellet05" 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 = "18294" select * from cotisations where identifiant = "m.bellet05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171119 payment_means : VISA transmission_date : 20161214161119 payment_time : 171447 payment_date : 20161214 response_code : 00 payment_certificate : 121a27343a74 authorisation_id : 597005 currency_code : 978 card_number : 4974.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.bellet05 order_id : 18294 customer_email : m.bellet05@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 = "18295" select * from cms_frontusers where identifiant = "g.vendeville15" 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 = "18295" select * from cotisations where identifiant = "g.vendeville15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 181010 payment_means : VISA transmission_date : 20161214171010 payment_time : 181121 payment_date : 20161214 response_code : 00 payment_certificate : a9b8de1911e1 authorisation_id : 732372 currency_code : 978 card_number : 4978.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.vendeville15 order_id : 18295 customer_email : g.vendeville15@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 = "18296" select * from cms_frontusers where identifiant = "f.poillot09" 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 = "18296" select * from cotisations where identifiant = "p.benayon30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181402 payment_means : VISA transmission_date : 20161214171402 payment_time : 181644 payment_date : 20161214 response_code : 00 payment_certificate : 5934a07c24c2 authorisation_id : 624898 currency_code : 978 card_number : 4533.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 : f.poillot09 order_id : 18296 customer_email : f.poillot09@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 = "18297" select * from cms_frontusers where identifiant = "a.escouvois03" 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 = "18297" select * from cotisations where identifiant = "a.escouvois03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182259 payment_means : MASTERCARD transmission_date : 20161214172259 payment_time : 182556 payment_date : 20161214 response_code : 00 payment_certificate : c77307aa78c8 authorisation_id : 403016 currency_code : 978 card_number : 5135.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 : a.escouvois03 order_id : 18297 customer_email : a.escouvois03@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 = "18298" select * from cms_frontusers where identifiant = "a.escouvois03" 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 = "18298" select * from cotisations where identifiant = "t.lemarchand18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182733 payment_means : MASTERCARD transmission_date : 20161214172733 payment_time : 182852 payment_date : 20161214 response_code : 00 payment_certificate : 3181d29c35fa authorisation_id : 727813 currency_code : 978 card_number : 5135.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 : a.escouvois03 order_id : 18298 customer_email : a.escouvois03@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 = "18293" select * from cms_frontusers where identifiant = "g.bonneville05" 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 = "18293" select * from cotisations where identifiant = "g.bonneville05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 161236 payment_means : VISA transmission_date : 20161214151236 payment_time : 183157 payment_date : 20161214 response_code : 00 payment_certificate : 7a7c013653cc authorisation_id : 602306 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 : g.bonneville05 order_id : 18293 customer_email : g.bonneville05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183904 payment_means : VISA transmission_date : 20161214173904 payment_time : 184057 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.65 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.lepand11 order_id : 18299 customer_email : a.lepand11@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 = "18299" select * from cms_frontusers where identifiant = "a.lepand11" 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 = "18299" select * from cotisations where identifiant = "k.philippe27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184106 payment_means : VISA transmission_date : 20161214174106 payment_time : 184201 payment_date : 20161214 response_code : 00 payment_certificate : 9b915966cd2d authorisation_id : 665424 currency_code : 978 card_number : 4976.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.lepand11 order_id : 18299 customer_email : a.lepand11@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 = "18301" select * from cms_frontusers where identifiant = "n.picard11" 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 = "18301" select * from cotisations where identifiant = "n.picard11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184829 payment_means : MASTERCARD transmission_date : 20161214174829 payment_time : 184940 payment_date : 20161214 response_code : 00 payment_certificate : f936de95e6b8 authorisation_id : 194386 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 : n.picard11 order_id : 18301 customer_email : n.picard11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18302" select * from cms_frontusers where identifiant = "l.colin15" 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 = "18302" select * from cotisations where identifiant = "l.colin15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190639 payment_means : MASTERCARD transmission_date : 20161214180639 payment_time : 190756 payment_date : 20161214 response_code : 00 payment_certificate : 40015eb9df93 authorisation_id : 963463 currency_code : 978 card_number : 5136.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.colin15 order_id : 18302 customer_email : l.colin15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18303" select * from cms_frontusers where identifiant = "j.fonseca20" 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 = "18303" select * from cotisations where identifiant = "j.fonseca20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192707 payment_means : VISA transmission_date : 20161214182707 payment_time : 192805 payment_date : 20161214 response_code : 00 payment_certificate : 17f3aed73a1f authorisation_id : 560251 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 : j.fonseca20 order_id : 18303 customer_email : j.fonseca20@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 = "18304" select * from cms_frontusers where identifiant = "j.fonseca20" 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 = "18304" select * from cotisations where identifiant = "s.guery08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192854 payment_means : VISA transmission_date : 20161214182854 payment_time : 193202 payment_date : 20161214 response_code : 00 payment_certificate : d16e66e80b34 authorisation_id : 885445 currency_code : 978 card_number : 4561.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 : j.fonseca20 order_id : 18304 customer_email : j.fonseca20@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 = "18305" select * from cms_frontusers where identifiant = "s.millard07" 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 = "18305" select * from cotisations where identifiant = "b.debout25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194704 payment_means : VISA transmission_date : 20161214184704 payment_time : 195135 payment_date : 20161214 response_code : 00 payment_certificate : cfb1aa20b57c authorisation_id : 204442 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 : s.millard07 order_id : 18305 customer_email : s.millard07@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 : 195557 payment_means : VISA transmission_date : 20161214185557 payment_time : 195806 payment_date : 20161214 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.morel01 order_id : 18306 customer_email : j.morel01@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 = "18307" select * from cms_frontusers where identifiant = "a.issertes14" 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 = "18307" select * from cotisations where identifiant = "a.issertes14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195937 payment_means : MASTERCARD transmission_date : 20161214185937 payment_time : 200205 payment_date : 20161214 response_code : 00 payment_certificate : fca292fdfae2 authorisation_id : 167201 currency_code : 978 card_number : 5137.84 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.issertes14 order_id : 18307 customer_email : a.issertes14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18308" select * from cms_frontusers where identifiant = "p.jouan06" 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 = "18308" select * from cotisations where identifiant = "p.jouan06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200524 payment_means : MASTERCARD transmission_date : 20161214190524 payment_time : 200809 payment_date : 20161214 response_code : 00 payment_certificate : ace929a77d80 authorisation_id : 421685 currency_code : 978 card_number : 5406.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.jouan06 order_id : 18308 customer_email : p.jouan06@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 = "18309" select * from cms_frontusers where identifiant = "e.lienhard03" 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 = "18309" select * from cotisations where identifiant = "e.lienhard03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200751 payment_means : MASTERCARD transmission_date : 20161214190751 payment_time : 201112 payment_date : 20161214 response_code : 00 payment_certificate : 2085a18cbdec authorisation_id : 171262 currency_code : 978 card_number : 5132.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 : e.lienhard03 order_id : 18309 customer_email : e.lienhard03@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 = "18310" select * from cms_frontusers where identifiant = "v.quiviger21" 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 = "18310" select * from cotisations where identifiant = "v.quiviger21" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "s.legoff12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 201300 payment_means : MASTERCARD transmission_date : 20161214191300 payment_time : 201512 payment_date : 20161214 response_code : 00 payment_certificate : bf6285d7cb5c authorisation_id : 429133 currency_code : 978 card_number : 5137.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 : v.quiviger21 order_id : 18310 customer_email : v.quiviger21@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 = "18311" select * from cms_frontusers where identifiant = "j.sittler07" 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 = "18311" select * from cotisations where identifiant = "j.sittler07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202001 payment_means : VISA transmission_date : 20161214192001 payment_time : 202133 payment_date : 20161214 response_code : 00 payment_certificate : a8534cd08c53 authorisation_id : 418963 currency_code : 978 card_number : 4974.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 : j.sittler07 order_id : 18311 customer_email : j.sittler07@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 = "18312" select * from cms_frontusers where identifiant = "d.sanchez26" 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 = "18312" select * from cotisations where identifiant = "o.lacaze22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202526 payment_means : MASTERCARD transmission_date : 20161214192526 payment_time : 202655 payment_date : 20161214 response_code : 00 payment_certificate : a8a2de1a4884 authorisation_id : 547275 currency_code : 978 card_number : 5137.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.sanchez26 order_id : 18312 customer_email : d.sanchez26@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 = "18313" select * from cms_frontusers where identifiant = "f.legendre22" 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 = "18313" select * from cotisations where identifiant = "f.legendre22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202627 payment_means : MASTERCARD transmission_date : 20161214192627 payment_time : 202949 payment_date : 20161214 response_code : 00 payment_certificate : 2f5ac2703a68 authorisation_id : 623648 currency_code : 978 card_number : 5130.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 : f.legendre22 order_id : 18313 customer_email : f.legendre22@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203530 payment_means : CB transmission_date : 20161214193530 payment_time : 203640 payment_date : 20161214 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 56 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.pringuenon08 order_id : 18316 customer_email : p.pringuenon08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18316" select * from cms_frontusers where identifiant = "p.pringuenon08" 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 = "18316" select * from cotisations where identifiant = "c.lamrani12" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "c.lamrani12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203712 payment_means : VISA transmission_date : 20161214193712 payment_time : 203833 payment_date : 20161214 response_code : 00 payment_certificate : 2e6d3a534fca authorisation_id : 201517 currency_code : 978 card_number : 4973.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 : p.pringuenon08 order_id : 18316 customer_email : p.pringuenon08@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 = "18317" select * from cms_frontusers where identifiant = "m.preteux08" 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 = "18317" select * from cotisations where identifiant = "m.preteux08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203534 payment_means : VISA transmission_date : 20161214193534 payment_time : 203906 payment_date : 20161214 response_code : 00 payment_certificate : fe09554c2d7c authorisation_id : 372411 currency_code : 978 card_number : 4974.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 : m.preteux08 order_id : 18317 customer_email : m.preteux08@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 : 203512 payment_means : VISA transmission_date : 20161214193512 payment_time : 203924 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.51 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.borde23 order_id : 18315 customer_email : m.borde23@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 = "18319" select * from cms_frontusers where identifiant = "g.dupeyron25" 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 = "18319" select * from cotisations where identifiant = "g.dupeyron25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203801 payment_means : VISA transmission_date : 20161214193801 payment_time : 204213 payment_date : 20161214 response_code : 00 payment_certificate : 91c057c6549a authorisation_id : 973231 currency_code : 978 card_number : 4562.41 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.dupeyron25 order_id : 18319 customer_email : g.dupeyron25@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 : 204255 payment_means : VISA transmission_date : 20161214194255 payment_time : 204355 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.36 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.pringuenon08 order_id : 18321 customer_email : p.pringuenon08@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 : 201904 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 : 204359 payment_means : VISA transmission_date : 20161214194359 payment_time : 204509 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.36 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.pringuenon08 order_id : 18321 customer_email : p.pringuenon08@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 : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18320" select * from cms_frontusers where identifiant = "q.poirier13" 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 = "18320" select * from cotisations where identifiant = "q.poirier13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203815 payment_means : MASTERCARD transmission_date : 20161214193815 payment_time : 204801 payment_date : 20161214 response_code : 00 payment_certificate : a718c695ac13 authorisation_id : 342631 currency_code : 978 card_number : 5817.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.poirier13 order_id : 18320 customer_email : q.poirier13@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 = "18322" select * from cms_frontusers where identifiant = "p.pringuenon08" 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 = "18322" select * from cotisations where identifiant = "j.largy07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204652 payment_means : VISA transmission_date : 20161214194652 payment_time : 204820 payment_date : 20161214 response_code : 00 payment_certificate : 6922482c4a9b authorisation_id : 834282 currency_code : 978 card_number : 4973.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 : p.pringuenon08 order_id : 18322 customer_email : p.pringuenon08@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 = "18323" select * from cms_frontusers where identifiant = "f.piller17" 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 = "18323" select * from cotisations where identifiant = "f.piller17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205415 payment_means : VISA transmission_date : 20161214195415 payment_time : 205547 payment_date : 20161214 response_code : 00 payment_certificate : 238c64a1e9bf authorisation_id : 446131 currency_code : 978 card_number : 4970.19 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.piller17 order_id : 18323 customer_email : f.piller17@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 = "18325" select * from cms_frontusers where identifiant = "b.jacquart05" 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 = "18325" select * from cotisations where identifiant = "b.jacquart05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210650 payment_means : MASTERCARD transmission_date : 20161214200650 payment_time : 210931 payment_date : 20161214 response_code : 00 payment_certificate : 58c1712a9f49 authorisation_id : 851252 currency_code : 978 card_number : 5131.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.jacquart05 order_id : 18325 customer_email : b.jacquart05@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 = "18324" select * from cms_frontusers where identifiant = "j.lajambe20" 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 = "18324" select * from cotisations where identifiant = "j.lajambe20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210349 payment_means : MASTERCARD transmission_date : 20161214200349 payment_time : 211024 payment_date : 20161214 response_code : 00 payment_certificate : 6911c170678d authorisation_id : 121572 currency_code : 978 card_number : 5132.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.lajambe20 order_id : 18324 customer_email : j.lajambe20@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 = "18326" select * from cms_frontusers where identifiant = "c.david11" 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 = "18326" select * from cotisations where identifiant = "c.david11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210805 payment_means : VISA transmission_date : 20161214200805 payment_time : 211026 payment_date : 20161214 response_code : 00 payment_certificate : 1cc873b8b215 authorisation_id : 630533 currency_code : 978 card_number : 4976.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 : c.david11 order_id : 18326 customer_email : c.david11@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 = "18327" select * from cms_frontusers where identifiant = "t.cyrille22" 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 = "18327" select * from cotisations where identifiant = "t.cyrille22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211105 payment_means : VISA transmission_date : 20161214201105 payment_time : 211310 payment_date : 20161214 response_code : 00 payment_certificate : fa4483356418 authorisation_id : 241488 currency_code : 978 card_number : 4978.82 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.cyrille22 order_id : 18327 customer_email : t.cyrille22@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 = "18328" select * from cms_frontusers where identifiant = "p.jover13" 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 = "18328" select * from cotisations where identifiant = "p.jover13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211625 payment_means : VISA transmission_date : 20161214201625 payment_time : 211806 payment_date : 20161214 response_code : 00 payment_certificate : 2afe9c1c8f10 authorisation_id : 363295 currency_code : 978 card_number : 4533.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.jover13 order_id : 18328 customer_email : p.jover13@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211802 payment_means : VISA transmission_date : 20161214201802 payment_time : 212429 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.81 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.vian10 order_id : 18329 customer_email : j.vian10@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18331" select * from cms_frontusers where identifiant = "m.latard14" 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 = "18331" select * from cotisations where identifiant = "m.latard14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212645 payment_means : MASTERCARD transmission_date : 20161214202645 payment_time : 213008 payment_date : 20161214 response_code : 00 payment_certificate : 27dd608811ea authorisation_id : 356066 currency_code : 978 card_number : 5132.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 : m.latard14 order_id : 18331 customer_email : m.latard14@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 = "18330" select * from cms_frontusers where identifiant = "j.assemat01" 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 = "18330" select * from cotisations where identifiant = "j.assemat01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212459 payment_means : VISA transmission_date : 20161214202459 payment_time : 213019 payment_date : 20161214 response_code : 00 payment_certificate : 39b2d6013e8f authorisation_id : 465631 currency_code : 978 card_number : 4970.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.assemat01 order_id : 18330 customer_email : j.assemat01@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 = "18334" select * from cms_frontusers where identifiant = "j.assemat01" 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 = "18334" select * from cotisations where identifiant = "j.assemat01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213144 payment_means : VISA transmission_date : 20161214203144 payment_time : 213457 payment_date : 20161214 response_code : 00 payment_certificate : f57e4fd4bf1d authorisation_id : 328236 currency_code : 978 card_number : 4970.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.assemat01 order_id : 18334 customer_email : j.assemat01@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 = "18332" select * from cms_frontusers where identifiant = "a.renaud28" 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 = "18332" select * from cotisations where identifiant = "a.renaud28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212739 payment_means : MASTERCARD transmission_date : 20161214202739 payment_time : 213731 payment_date : 20161214 response_code : 00 payment_certificate : 2aa2e335d555 authorisation_id : 644688 currency_code : 978 card_number : 5132.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 : a.renaud28 order_id : 18332 customer_email : a.renaud28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18335" select * from cms_frontusers where identifiant = "l.morgano06" 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 = "18335" select * from cotisations where identifiant = "l.morgano06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213807 payment_means : VISA transmission_date : 20161214203807 payment_time : 214052 payment_date : 20161214 response_code : 00 payment_certificate : 20d911dec7db authorisation_id : 223312 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 : l.morgano06 order_id : 18335 customer_email : l.morgano06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215329 payment_means : VISA transmission_date : 20161214205329 payment_time : 215555 payment_date : 20161214 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.53 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 : h.duina25 order_id : 18336 customer_email : h.duina25@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18337" select * from cms_frontusers where identifiant = "e.rinaldo15" 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 = "18337" select * from cotisations where identifiant = "e.rinaldo15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215543 payment_means : VISA transmission_date : 20161214205543 payment_time : 220006 payment_date : 20161214 response_code : 00 payment_certificate : cd7f78cbdd4d authorisation_id : 112453 currency_code : 978 card_number : 4561.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 : e.rinaldo15 order_id : 18337 customer_email : e.rinaldo15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215850 payment_means : VISA transmission_date : 20161214205850 payment_time : 220040 payment_date : 20161214 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 57 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.ory21 order_id : 18339 customer_email : t.ory21@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 = "18342" select * from cms_frontusers where identifiant = "f.ortscheid09" 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 = "18342" select * from cotisations where identifiant = "s.popovitch29" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "m.loth06" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "m.loth06" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "f.rodrigue01" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "f.schwaller14" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "j.emeriaud04" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "e.grangergirault04" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "p.kieffer28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 56000 transaction_id : 221948 payment_means : MASTERCARD transmission_date : 20161214211948 payment_time : 222240 payment_date : 20161214 response_code : 00 payment_certificate : 6f7c21927079 authorisation_id : 328788 currency_code : 978 card_number : 5132.32 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.ortscheid09 order_id : 18342 customer_email : f.ortscheid09@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 = "18341" select * from cms_frontusers where identifiant = "t.thiriot27" 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 = "18341" select * from cotisations where identifiant = "s.paques02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221942 payment_means : VISA transmission_date : 20161214211942 payment_time : 222319 payment_date : 20161214 response_code : 00 payment_certificate : e955335df1c3 authorisation_id : 663260 currency_code : 978 card_number : 4976.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 : t.thiriot27 order_id : 18341 customer_email : t.thiriot27@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 = "18343" select * from cms_frontusers where identifiant = "t.thiriot27" 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 = "18343" select * from cotisations where identifiant = "a.ladeiro13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222402 payment_means : VISA transmission_date : 20161214212402 payment_time : 222552 payment_date : 20161214 response_code : 00 payment_certificate : e6c488c6fd90 authorisation_id : 631146 currency_code : 978 card_number : 4976.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 : t.thiriot27 order_id : 18343 customer_email : t.thiriot27@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 = "18345" select * from cms_frontusers where identifiant = "y.provost07" 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 = "18345" select * from cotisations where identifiant = "y.provost07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 223219 payment_means : MASTERCARD transmission_date : 20161214213219 payment_time : 223500 payment_date : 20161214 response_code : 00 payment_certificate : e4e8a04dc7a2 authorisation_id : 694131 currency_code : 978 card_number : 5130.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.provost07 order_id : 18345 customer_email : y.provost07@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 = "18348" select * from cms_frontusers where identifiant = "h.duina25" 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 = "18348" select * from cotisations where identifiant = "h.duina25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225246 payment_means : VISA transmission_date : 20161214215246 payment_time : 225459 payment_date : 20161214 response_code : 00 payment_certificate : eae1332d21f0 authorisation_id : 647721 currency_code : 978 card_number : 4972.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 : h.duina25 order_id : 18348 customer_email : h.duina25@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 = "18350" select * from cms_frontusers where identifiant = "f.petit28" 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 = "18350" select * from cotisations where identifiant = "f.petit28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 230706 payment_means : VISA transmission_date : 20161214220706 payment_time : 231110 payment_date : 20161214 response_code : 00 payment_certificate : 30f31e915f34 authorisation_id : 452395 currency_code : 978 card_number : 4974.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.petit28 order_id : 18350 customer_email : f.petit28@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 = "18352" select * from cms_frontusers where identifiant = "h.blanc24" 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 = "18352" select * from cotisations where identifiant = "h.blanc24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 233755 payment_means : VISA transmission_date : 20161214223755 payment_time : 234100 payment_date : 20161214 response_code : 00 payment_certificate : 04faf32ae709 authorisation_id : 921625 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 : h.blanc24 order_id : 18352 customer_email : h.blanc24@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 : -------------------------------------------