Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083531 payment_means : MASTERCARD transmission_date : 20151027073531 payment_time : 083632 payment_date : 20151027 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.vuidel10 order_id : 8147 customer_email : j.vuidel10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083643 payment_means : MASTERCARD transmission_date : 20151027073643 payment_time : 083739 payment_date : 20151027 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.vuidel10 order_id : 8147 customer_email : j.vuidel10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8148" select * from cms_frontusers where identifiant = "m.ascheri14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8148" select * from cotisations where identifiant = "m.ascheri14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 095923 payment_means : MASTERCARD transmission_date : 20151027085923 payment_time : 100057 payment_date : 20151027 response_code : 00 payment_certificate : cf493bb0e66f authorisation_id : 175576 currency_code : 978 card_number : 5131.61 cvv_flag : 1 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.ascheri14 order_id : 8148 customer_email : m.ascheri14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 115205 payment_means : MASTERCARD transmission_date : 20151027105205 payment_time : 115535 payment_date : 20151027 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5275.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.david31 order_id : 8149 customer_email : c.david31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201701 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155735 payment_means : MASTERCARD transmission_date : 20151027145735 payment_time : 155906 payment_date : 20151027 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : pg.commeureuc15 order_id : 8150 customer_email : pg.commeureuc15@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 : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8151" select * from cms_frontusers where identifiant = "p.grandemange20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8151" select * from cotisations where identifiant = "p.grandemange20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165257 payment_means : MASTERCARD transmission_date : 20151027155257 payment_time : 165514 payment_date : 20151027 response_code : 00 payment_certificate : 01b511b94ae9 authorisation_id : 252465 currency_code : 978 card_number : 5132.97 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.grandemange20 order_id : 8151 customer_email : p.grandemange20@compagnons-du-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 = "8152" select * from cms_frontusers where identifiant = "m.girondeau09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8152" select * from cotisations where identifiant = "m.girondeau09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171047 payment_means : MASTERCARD transmission_date : 20151027161047 payment_time : 171240 payment_date : 20151027 response_code : 00 payment_certificate : 7d0a96816bb7 authorisation_id : 976546 currency_code : 978 card_number : 5341.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.girondeau09 order_id : 8152 customer_email : m.girondeau09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8154" select * from cms_frontusers where identifiant = "f.weyhaubt30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8154" select * from cotisations where identifiant = "f.weyhaubt30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175232 payment_means : MASTERCARD transmission_date : 20151027165232 payment_time : 175414 payment_date : 20151027 response_code : 00 payment_certificate : b041336105f6 authorisation_id : 660246 currency_code : 978 card_number : 5132.72 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.weyhaubt30 order_id : 8154 customer_email : f.weyhaubt30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8155" select * from cms_frontusers where identifiant = "r.dagois22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8155" select * from cotisations where identifiant = "r.dagois22" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182522 payment_means : MASTERCARD transmission_date : 20151027172522 payment_time : 182819 payment_date : 20151027 response_code : 00 payment_certificate : 5d6b13e8c4d1 authorisation_id : 483845 currency_code : 978 card_number : 5131.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.dagois22 order_id : 8155 customer_email : r.dagois22@compagnons-du-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 = "8157" select * from cms_frontusers where identifiant = "l.lentacker22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8157" select * from cotisations where identifiant = "l.lentacker22" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 193622 payment_means : VISA transmission_date : 20151027183622 payment_time : 193829 payment_date : 20151027 response_code : 00 payment_certificate : 022e867de028 authorisation_id : 236436 currency_code : 978 card_number : 4970.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 : l.lentacker22 order_id : 8157 customer_email : l.lentacker22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8159" select * from cms_frontusers where identifiant = "j.lemartinel15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8159" select * from cotisations where identifiant = "c.florentin18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195929 payment_means : VISA transmission_date : 20151027185929 payment_time : 200203 payment_date : 20151027 response_code : 00 payment_certificate : a4c4a80d4c17 authorisation_id : 530381 currency_code : 978 card_number : 4978.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 : j.lemartinel15 order_id : 8159 customer_email : j.lemartinel15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8160" select * from cms_frontusers where identifiant = "j.lemartinel15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8160" select * from cotisations where identifiant = "j.lemartinel15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200317 payment_means : VISA transmission_date : 20151027190317 payment_time : 200505 payment_date : 20151027 response_code : 00 payment_certificate : ba27683acdf3 authorisation_id : 698192 currency_code : 978 card_number : 4975.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 : j.lemartinel15 order_id : 8160 customer_email : j.lemartinel15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8163" select * from cms_frontusers where identifiant = "t.cadoret07" select * from cotisations_commande where id = "8162" select * from cms_frontusers where identifiant = "d.taupin15" Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200600 payment_means : VISA transmission_date : 20151027190600 payment_time : 201125 payment_date : 20151027 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.nicolai30 order_id : 8161 customer_email : c.nicolai30@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 : 201807 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8163" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8162" select * from cotisations where identifiant = "t.cadoret07" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "d.taupin15" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200851 payment_means : VISA transmission_date : 20151027190851 payment_time : 201043 payment_date : 20151027 response_code : 00 payment_certificate : 08b7a208ae67 authorisation_id : 640513 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 : d.taupin15 order_id : 8162 customer_email : d.taupin15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : code : 0 order_validity : 02 error : transaction_condition : 3D_SUCCESS merchant_id : 077566202600019 statement_reference : merchant_country : fr card_validity : 201606 amount : 4000 score_value : transaction_id : 200856 score_color : payment_means : MASTERCARD score_info : transmission_date : 20151027190856 score_threshold : payment_time : 201016 score_profile : payment_date : 20151027 ------------------------------------------- response_code : 00 payment_certificate : f04783d81466 authorisation_id : 204563 currency_code : 978 card_number : 5137.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 : t.cadoret07 order_id : 8163 customer_email : t.cadoret07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201352 payment_means : MASTERCARD transmission_date : 20151027191352 payment_time : 202012 payment_date : 20151027 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.hannier20 order_id : 8165 customer_email : t.hannier20@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 : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8166" select * from cms_frontusers where identifiant = "b.deleau19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8166" select * from cotisations where identifiant = "b.deleau19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201849 payment_means : MASTERCARD transmission_date : 20151027191849 payment_time : 202129 payment_date : 20151027 response_code : 00 payment_certificate : 2fdbbdee9868 authorisation_id : 260866 currency_code : 978 card_number : 5132.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.deleau19 order_id : 8166 customer_email : b.deleau19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8167" select * from cms_frontusers where identifiant = "b.thierry17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8167" select * from cotisations where identifiant = "b.thierry17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204404 payment_means : VISA transmission_date : 20151027194404 payment_time : 205841 payment_date : 20151027 response_code : 00 payment_certificate : cafa3846b6fd authorisation_id : 458277 currency_code : 978 card_number : 4150.87 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.thierry17 order_id : 8167 customer_email : b.thierry17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8169" select * from cms_frontusers where identifiant = "b.thierry17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8169" select * from cotisations where identifiant = "b.thierry17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210456 payment_means : VISA transmission_date : 20151027200456 payment_time : 210623 payment_date : 20151027 response_code : 00 payment_certificate : a790af171cd7 authorisation_id : 367501 currency_code : 978 card_number : 4150.93 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.thierry17 order_id : 8169 customer_email : b.thierry17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8170" select * from cms_frontusers where identifiant = "v.cloquemin01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8170" select * from cotisations where identifiant = "v.cloquemin01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211822 payment_means : VISA transmission_date : 20151027201822 payment_time : 212217 payment_date : 20151027 response_code : 00 payment_certificate : dec4914cba69 authorisation_id : 868421 currency_code : 978 card_number : 4970.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.cloquemin01 order_id : 8170 customer_email : v.cloquemin01@compagnons-du-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 = "8172" select * from cms_frontusers where identifiant = "m.gillardin21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8172" select * from cotisations where identifiant = "w.dumonthestin07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212544 payment_means : MASTERCARD transmission_date : 20151027202544 payment_time : 212820 payment_date : 20151027 response_code : 00 payment_certificate : dc242fd323f5 authorisation_id : 456254 currency_code : 978 card_number : 5135.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.gillardin21 order_id : 8172 customer_email : m.gillardin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8173" select * from cms_frontusers where identifiant = "g.seignier20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8173" select * from cotisations where identifiant = "g.seignier20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213443 payment_means : VISA transmission_date : 20151027203443 payment_time : 213901 payment_date : 20151027 response_code : 00 payment_certificate : 2653eef2471d authorisation_id : 010823 currency_code : 978 card_number : 4974.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.seignier20 order_id : 8173 customer_email : g.seignier20@compagnons-du-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 = "8175" select * from cms_frontusers where identifiant = "n.francois11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8175" select * from cotisations where identifiant = "n.francois11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215025 payment_means : MASTERCARD transmission_date : 20151027205025 payment_time : 215259 payment_date : 20151027 response_code : 00 payment_certificate : 1af42d829fdf authorisation_id : 757242 currency_code : 978 card_number : 5131.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.francois11 order_id : 8175 customer_email : n.francois11@compagnons-du-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 = "8177" select * from cms_frontusers where identifiant = "py.vuilliot18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8177" select * from cotisations where identifiant = "py.vuilliot18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220251 payment_means : MASTERCARD transmission_date : 20151027210251 payment_time : 220500 payment_date : 20151027 response_code : 00 payment_certificate : 64414281e573 authorisation_id : 844273 currency_code : 978 card_number : 5131.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : py.vuilliot18 order_id : 8177 customer_email : py.vuilliot18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------