select * from cotisations_commande where id = "13128" select * from cms_frontusers where identifiant = "k.gendry20" 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 = "13128" select * from cotisations where identifiant = "k.gendry20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080129 payment_means : MASTERCARD transmission_date : 20160125070129 payment_time : 080431 payment_date : 20160125 response_code : 00 payment_certificate : 44f5b3ce6307 authorisation_id : 372105 currency_code : 978 card_number : 5132.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 : k.gendry20 order_id : 13128 customer_email : k.gendry20@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 : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13129" select * from cms_frontusers where identifiant = "s.berline13" 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 = "13129" select * from cotisations where identifiant = "s.berline13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083152 payment_means : VISA transmission_date : 20160125073152 payment_time : 083352 payment_date : 20160125 response_code : 00 payment_certificate : 9448438905c1 authorisation_id : 304224 currency_code : 978 card_number : 4562.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 : s.berline13 order_id : 13129 customer_email : s.berline13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135603 payment_means : MASTERCARD transmission_date : 20160125125603 payment_time : 135739 payment_date : 20160125 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5188.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 20 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.bachelier11 order_id : 13133 customer_email : b.bachelier11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13133" select * from cms_frontusers where identifiant = "b.bachelier11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "13133" select * from cotisations where identifiant = "b.bachelier11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135757 payment_means : MASTERCARD transmission_date : 20160125125757 payment_time : 140006 payment_date : 20160125 response_code : 00 payment_certificate : 32e19fba947e authorisation_id : 208602 currency_code : 978 card_number : 5188.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 : b.bachelier11 order_id : 13133 customer_email : b.bachelier11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13134" select * from cms_frontusers where identifiant = "f.miniou05" 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 = "13134" select * from cotisations where identifiant = "b.saussereau01" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "b.saussereau01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140458 payment_means : MASTERCARD transmission_date : 20160125130458 payment_time : 140717 payment_date : 20160125 response_code : 00 payment_certificate : 91b6baf85533 authorisation_id : 532656 currency_code : 978 card_number : 5131.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.miniou05 order_id : 13134 customer_email : f.miniou05@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 = "13135" select * from cms_frontusers where identifiant = "f.miniou05" 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 = "13135" select * from cotisations where identifiant = "e.peres27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 140803 payment_means : VISA transmission_date : 20160125130803 payment_time : 141138 payment_date : 20160125 response_code : 00 payment_certificate : 1f25c88700d2 authorisation_id : 101554 currency_code : 978 card_number : 4978.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 : f.miniou05 order_id : 13135 customer_email : f.miniou05@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 = "13136" select * from cms_frontusers where identifiant = "a.mace10" 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 = "13136" select * from cotisations where identifiant = "a.mace10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141220 payment_means : MASTERCARD transmission_date : 20160125131220 payment_time : 141451 payment_date : 20160125 response_code : 00 payment_certificate : 64a86e41a3b6 authorisation_id : 793835 currency_code : 978 card_number : 5131.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.mace10 order_id : 13136 customer_email : a.mace10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 141608 payment_means : MASTERCARD transmission_date : 20160125131608 payment_time : 141735 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5612.23 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 : f.miniou05 order_id : 13137 customer_email : f.miniou05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13137" select * from cms_frontusers where identifiant = "f.miniou05" 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 = "13137" select * from cotisations where identifiant = "m.pascal29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 141741 payment_means : MASTERCARD transmission_date : 20160125131741 payment_time : 142130 payment_date : 20160125 response_code : 00 payment_certificate : 11cee7a88bfc authorisation_id : 526784 currency_code : 978 card_number : 5612.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 : f.miniou05 order_id : 13137 customer_email : f.miniou05@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 : 142303 payment_means : VISA transmission_date : 20160125132303 payment_time : 142408 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4562.41 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 : f.miniou05 order_id : 13138 customer_email : f.miniou05@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 : 4000 transaction_id : 142421 payment_means : VISA transmission_date : 20160125132421 payment_time : 142907 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4562.41 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 : f.miniou05 order_id : 13138 customer_email : f.miniou05@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 = "13139" select * from cms_frontusers where identifiant = "f.dhume12" 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 = "13139" select * from cotisations where identifiant = "f.dhume12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152645 payment_means : VISA transmission_date : 20160125142645 payment_time : 152756 payment_date : 20160125 response_code : 00 payment_certificate : 919777d757c3 authorisation_id : 241632 currency_code : 978 card_number : 4978.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.dhume12 order_id : 13139 customer_email : f.dhume12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170103 payment_means : VISA transmission_date : 20160125160103 payment_time : 170843 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.63 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 : h.montanier04 order_id : 13140 customer_email : h.montanier04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170900 payment_means : VISA transmission_date : 20160125160900 payment_time : 171448 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.63 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 : h.montanier04 order_id : 13140 customer_email : h.montanier04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171644 payment_means : MASTERCARD transmission_date : 20160125161644 payment_time : 172104 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.04 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 : jn.casse23 order_id : 13141 customer_email : jn.casse23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173648 payment_means : VISA transmission_date : 20160125163648 payment_time : 173817 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4627.94 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 : g.jamet07 order_id : 13142 customer_email : g.jamet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173846 payment_means : MASTERCARD transmission_date : 20160125163846 payment_time : 174015 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.94 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 : g.jamet07 order_id : 13142 customer_email : g.jamet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174022 payment_means : VISA transmission_date : 20160125164022 payment_time : 174123 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4627.94 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 : g.jamet07 order_id : 13142 customer_email : g.jamet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13144" select * from cms_frontusers where identifiant = "a.coulaud24" 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 = "13144" select * from cotisations where identifiant = "a.coulaud24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 181456 payment_means : VISA transmission_date : 20160125171456 payment_time : 181646 payment_date : 20160125 response_code : 00 payment_certificate : c89c7e837d6a authorisation_id : 532321 currency_code : 978 card_number : 4150.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 : a.coulaud24 order_id : 13144 customer_email : a.coulaud24@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 : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13145" select * from cms_frontusers where identifiant = "l.haeringer25" 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 = "13145" select * from cotisations where identifiant = "c.melchiademathieu14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182551 payment_means : VISA transmission_date : 20160125172551 payment_time : 182910 payment_date : 20160125 response_code : 00 payment_certificate : 6cfcbf0144da authorisation_id : 956286 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 : l.haeringer25 order_id : 13145 customer_email : l.haeringer25@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 = "13146" 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 = "13146" select * from cotisations where identifiant = "jm.thiebault03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190010 payment_means : MASTERCARD transmission_date : 20160125180010 payment_time : 190143 payment_date : 20160125 response_code : 00 payment_certificate : 143be27ea53c authorisation_id : 184248 currency_code : 978 card_number : 5131.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.tristant19 order_id : 13146 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 = "13147" select * from cms_frontusers where identifiant = "f.piquet29" 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 = "13147" select * from cotisations where identifiant = "f.piquet29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190145 payment_means : VISA transmission_date : 20160125180145 payment_time : 190259 payment_date : 20160125 response_code : 00 payment_certificate : 2bff30cb8055 authorisation_id : 035478 currency_code : 978 card_number : 4978.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 : f.piquet29 order_id : 13147 customer_email : f.piquet29@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 : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13148" select * from cms_frontusers where identifiant = "t.chevrier19" 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 = "13148" select * from cotisations where identifiant = "t.chevrier19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191525 payment_means : VISA transmission_date : 20160125181525 payment_time : 191941 payment_date : 20160125 response_code : 00 payment_certificate : 9ab541264670 authorisation_id : 223351 currency_code : 978 card_number : 4973.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 : t.chevrier19 order_id : 13148 customer_email : t.chevrier19@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 = "13149" select * from cms_frontusers where identifiant = "t.dechamps31" 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 = "13149" select * from cotisations where identifiant = "t.dechamps31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195707 payment_means : VISA transmission_date : 20160125185707 payment_time : 200038 payment_date : 20160125 response_code : 00 payment_certificate : af1ea8f30b7f authorisation_id : 675131 currency_code : 978 card_number : 4978.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.dechamps31 order_id : 13149 customer_email : t.dechamps31@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 = "13150" select * from cms_frontusers where identifiant = "jm.aupee28" 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 = "13150" select * from cotisations where identifiant = "a.diaz11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200939 payment_means : VISA transmission_date : 20160125190939 payment_time : 201122 payment_date : 20160125 response_code : 00 payment_certificate : dc901b86ced7 authorisation_id : 625268 currency_code : 978 card_number : 4978.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.aupee28 order_id : 13150 customer_email : jm.aupee28@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 : 201604 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 : 202008 payment_means : MASTERCARD transmission_date : 20160125192008 payment_time : 202241 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5542.39 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 : p.charpentier13 order_id : 13151 customer_email : p.charpentier13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13164" select * from cms_frontusers where identifiant = "j.ribollet01" 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 = "13164" select * from cotisations where identifiant = "j.ribollet01" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "j.ribollet01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205126 payment_means : MASTERCARD transmission_date : 20160125195126 payment_time : 205301 payment_date : 20160125 response_code : 00 payment_certificate : 891753a26449 authorisation_id : 543165 currency_code : 978 card_number : 5341.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 : j.ribollet01 order_id : 13164 customer_email : j.ribollet01@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 = "13165" select * from cms_frontusers where identifiant = "t.flament16" 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 = "13165" select * from cotisations where identifiant = "t.flament16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205937 payment_means : VISA transmission_date : 20160125195937 payment_time : 210050 payment_date : 20160125 response_code : 00 payment_certificate : 2f8dd582627c authorisation_id : 239597 currency_code : 978 card_number : 4978.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.flament16 order_id : 13165 customer_email : t.flament16@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 : 210207 payment_means : VISA transmission_date : 20160125200207 payment_time : 210353 payment_date : 20160125 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.85 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 : p.charpentier13 order_id : 13166 customer_email : p.charpentier13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13167" select * from cms_frontusers where identifiant = "m.bellia23" 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 = "13167" select * from cotisations where identifiant = "m.bellia23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212244 payment_means : VISA transmission_date : 20160125202244 payment_time : 212423 payment_date : 20160125 response_code : 00 payment_certificate : 419b1df17701 authorisation_id : 390026 currency_code : 978 card_number : 4978.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 : m.bellia23 order_id : 13167 customer_email : m.bellia23@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 = "13168" select * from cms_frontusers where identifiant = "e.dacostavieira29" 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 = "13168" select * from cotisations where identifiant = "e.dacostavieira29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212448 payment_means : MASTERCARD transmission_date : 20160125202448 payment_time : 212614 payment_date : 20160125 response_code : 00 payment_certificate : 06fece5e976d authorisation_id : 329241 currency_code : 978 card_number : 5131.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.dacostavieira29 order_id : 13168 customer_email : e.dacostavieira29@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13169" select * from cms_frontusers where identifiant = "a.gaudin16" 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 = "13169" select * from cotisations where identifiant = "j.robin14" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "j.robin14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213159 payment_means : VISA transmission_date : 20160125203159 payment_time : 214022 payment_date : 20160125 response_code : 00 payment_certificate : 22c441d97236 authorisation_id : 411744 currency_code : 978 card_number : 4970.92 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.gaudin16 order_id : 13169 customer_email : a.gaudin16@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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "13170" select * from cms_frontusers where identifiant = "m.rousseau07" 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 = "13170" select * from cotisations where identifiant = "m.rousseau07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215007 payment_means : VISA transmission_date : 20160125205007 payment_time : 215234 payment_date : 20160125 response_code : 00 payment_certificate : 45fa7b270368 authorisation_id : 642556 currency_code : 978 card_number : 4978.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.rousseau07 order_id : 13170 customer_email : m.rousseau07@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 = "13171" select * from cms_frontusers where identifiant = "c.lucier10" 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 = "13171" select * from cotisations where identifiant = "c.lucier10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220512 payment_means : MASTERCARD transmission_date : 20160125210512 payment_time : 220703 payment_date : 20160125 response_code : 00 payment_certificate : 3de4e18839b4 authorisation_id : 161416 currency_code : 978 card_number : 5131.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.lucier10 order_id : 13171 customer_email : c.lucier10@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 = "13172" select * from cms_frontusers where identifiant = "l.ouvrard18" 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 = "13172" select * from cotisations where identifiant = "l.ouvrard18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220746 payment_means : VISA transmission_date : 20160125210746 payment_time : 221031 payment_date : 20160125 response_code : 00 payment_certificate : e4d1d697f60a authorisation_id : 647530 currency_code : 978 card_number : 4970.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 : l.ouvrard18 order_id : 13172 customer_email : l.ouvrard18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221503 payment_means : VISA transmission_date : 20160125211503 payment_time : 221621 payment_date : 20160125 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.09 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 : t.wattiau29 order_id : 13174 customer_email : t.wattiau29@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 : -------------------------------------------