select * from cotisations_commande where id = "9137" select * from cms_frontusers where identifiant = "g.miesch10" 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 = "9137" select * from cotisations where identifiant = "g.miesch10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 084050 payment_means : MASTERCARD transmission_date : 20151120074050 payment_time : 084410 payment_date : 20151120 response_code : 00 payment_certificate : 07c9d42079f5 authorisation_id : 634526 currency_code : 978 card_number : 5132.98 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.miesch10 order_id : 9137 customer_email : g.miesch10@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 085637 payment_means : VISA transmission_date : 20151120075637 payment_time : 090318 payment_date : 20151120 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.13 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 : b.cadilhac04 order_id : 9138 customer_email : b.cadilhac04@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 : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9140" 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 = "9140" select * from cotisations where identifiant = "m.claus16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102146 payment_means : VISA transmission_date : 20151120092146 payment_time : 102342 payment_date : 20151120 response_code : 00 payment_certificate : fdad5ec454e4 authorisation_id : 256564 currency_code : 978 card_number : 4970.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.claus16 order_id : 9140 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 : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9141" select * from cms_frontusers where identifiant = "d.legall21" 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 = "9141" select * from cotisations where identifiant = "d.legall21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104343 payment_means : VISA transmission_date : 20151120094343 payment_time : 104617 payment_date : 20151120 response_code : 00 payment_certificate : 30e9d9d2df33 authorisation_id : 245211 currency_code : 978 card_number : 4972.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.legall21 order_id : 9141 customer_email : d.legall21@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 = "9142" select * from cms_frontusers where identifiant = "b.denicola21" 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 = "9142" select * from cotisations where identifiant = "w.tobal01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153345 payment_means : VISA transmission_date : 20151120143345 payment_time : 153521 payment_date : 20151120 response_code : 00 payment_certificate : 699898bd77ea authorisation_id : 611214 currency_code : 978 card_number : 4978.60 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.denicola21 order_id : 9142 customer_email : b.denicola21@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 : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "9143" select * from cms_frontusers where identifiant = "y.patient24" 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 = "9143" select * from cotisations where identifiant = "y.patient24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160336 payment_means : MASTERCARD transmission_date : 20151120150336 payment_time : 160619 payment_date : 20151120 response_code : 00 payment_certificate : 717fbe13fcca authorisation_id : 368666 currency_code : 978 card_number : 5131.10 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.patient24 order_id : 9143 customer_email : y.patient24@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 = "9144" select * from cms_frontusers where identifiant = "y.valentinuzzi23" 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 = "9144" select * from cotisations where identifiant = "y.valentinuzzi23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172203 payment_means : VISA transmission_date : 20151120162203 payment_time : 172354 payment_date : 20151120 response_code : 00 payment_certificate : 7aef0f29e4a1 authorisation_id : 244033 currency_code : 978 card_number : 4970.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 : y.valentinuzzi23 order_id : 9144 customer_email : y.valentinuzzi23@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 = "9145" select * from cms_frontusers where identifiant = "v.gaudin08" 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 = "9145" select * from cotisations where identifiant = "v.gaudin08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172533 payment_means : MASTERCARD transmission_date : 20151120162533 payment_time : 172652 payment_date : 20151120 response_code : 00 payment_certificate : 8db0a1437dd6 authorisation_id : 614138 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 : v.gaudin08 order_id : 9145 customer_email : v.gaudin08@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 = "9146" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "9146" select * from cotisations where identifiant = "y.genevois20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175638 payment_means : VISA transmission_date : 20151120165638 payment_time : 175810 payment_date : 20151120 response_code : 00 payment_certificate : 26b58afc411f authorisation_id : 465885 currency_code : 978 card_number : 4976.33 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.sbrava12 order_id : 9146 customer_email : l.sbrava12@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 = "9147" select * from cms_frontusers where identifiant = "l.sbrava12" 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 = "9147" select * from cotisations where identifiant = "y.genevois20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175846 payment_means : VISA transmission_date : 20151120165846 payment_time : 180002 payment_date : 20151120 response_code : 00 payment_certificate : 453f9ba27b1a authorisation_id : 390288 currency_code : 978 card_number : 4976.33 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.sbrava12 order_id : 9147 customer_email : l.sbrava12@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 = "9148" select * from cms_frontusers where identifiant = "b.vuylsteke13" 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 = "9148" select * from cotisations where identifiant = "b.vuylsteke13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 181551 payment_means : VISA transmission_date : 20151120171551 payment_time : 181718 payment_date : 20151120 response_code : 00 payment_certificate : 43e7c6feb929 authorisation_id : 575410 currency_code : 978 card_number : 4970.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 : b.vuylsteke13 order_id : 9148 customer_email : b.vuylsteke13@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 = "9149" select * from cms_frontusers where identifiant = "a.brisebard19" 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 = "9149" select * from cotisations where identifiant = "a.brisebard19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184332 payment_means : MASTERCARD transmission_date : 20151120174332 payment_time : 184523 payment_date : 20151120 response_code : 00 payment_certificate : b9af46a2523b authorisation_id : 668266 currency_code : 978 card_number : 5131.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.brisebard19 order_id : 9149 customer_email : a.brisebard19@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 = "9151" select * from cms_frontusers where identifiant = "v.descamps21" 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 = "9151" select * from cotisations where identifiant = "v.descamps21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190752 payment_means : VISA transmission_date : 20151120180752 payment_time : 190950 payment_date : 20151120 response_code : 00 payment_certificate : d8f58e37caf0 authorisation_id : 686557 currency_code : 978 card_number : 4971.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 : v.descamps21 order_id : 9151 customer_email : v.descamps21@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 = "9153" select * from cms_frontusers where identifiant = "a.labille23" 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 = "9153" select * from cotisations where identifiant = "a.labille23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202653 payment_means : MASTERCARD transmission_date : 20151120192653 payment_time : 202820 payment_date : 20151120 response_code : 00 payment_certificate : c4465e658643 authorisation_id : 705555 currency_code : 978 card_number : 5131.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 : a.labille23 order_id : 9153 customer_email : a.labille23@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 : ------------------------------------------- select * from cotisations_commande where id = "9154" select * from cms_frontusers where identifiant = "r.schaefer19" 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 = "9154" select * from cotisations where identifiant = "r.schaefer19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211702 payment_means : VISA transmission_date : 20151120201702 payment_time : 212117 payment_date : 20151120 response_code : 00 payment_certificate : dd8ed9e6e093 authorisation_id : 361830 currency_code : 978 card_number : 4970.45 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.schaefer19 order_id : 9154 customer_email : r.schaefer19@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 = "9155" select * from cms_frontusers where identifiant = "b.schultheiss21" 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 = "9155" select * from cotisations where identifiant = "b.schultheiss21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220635 payment_means : MASTERCARD transmission_date : 20151120210635 payment_time : 221111 payment_date : 20151120 response_code : 00 payment_certificate : 0e9e1141ac47 authorisation_id : 226383 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 : b.schultheiss21 order_id : 9155 customer_email : b.schultheiss21@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 = "9156" select * from cms_frontusers where identifiant = "d.valroff21" 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 = "9156" select * from cotisations where identifiant = "d.valroff21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222328 payment_means : MASTERCARD transmission_date : 20151120212328 payment_time : 222908 payment_date : 20151120 response_code : 00 payment_certificate : 27c9289a4ec7 authorisation_id : 530653 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 : d.valroff21 order_id : 9156 customer_email : d.valroff21@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 = "9157" select * from cms_frontusers where identifiant = "m.medeville05" 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 = "9157" select * from cotisations where identifiant = "m.medeville05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224437 payment_means : VISA transmission_date : 20151120214437 payment_time : 224544 payment_date : 20151120 response_code : 00 payment_certificate : 71c929a4f21c authorisation_id : 697286 currency_code : 978 card_number : 4976.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.medeville05 order_id : 9157 customer_email : m.medeville05@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 : -------------------------------------------