select * from cotisations_commande where id = "15897" select * from cms_frontusers where identifiant = "p.pasquier24" 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 = "15897" select * from cotisations where identifiant = "p.pasquier24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 061112 payment_means : VISA transmission_date : 20161115051112 payment_time : 061420 payment_date : 20161115 response_code : 00 payment_certificate : 3595cfcbc497 authorisation_id : 031435 currency_code : 978 card_number : 4059.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 : p.pasquier24 order_id : 15897 customer_email : p.pasquier24@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 = "15898" select * from cms_frontusers where identifiant = "g.chiffoleau23" 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 = "15898" select * from cotisations where identifiant = "g.chiffoleau23" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "g.chiffoleau23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 063113 payment_means : MASTERCARD transmission_date : 20161115053113 payment_time : 063436 payment_date : 20161115 response_code : 00 payment_certificate : e2d2e4d542f1 authorisation_id : 029411 currency_code : 978 card_number : 5130.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 : g.chiffoleau23 order_id : 15898 customer_email : g.chiffoleau23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15900" select * from cms_frontusers where identifiant = "j.winaudtumbach06" 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 = "15900" select * from cotisations where identifiant = "j.winaudtumbach06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 075930 payment_means : MASTERCARD transmission_date : 20161115065930 payment_time : 080033 payment_date : 20161115 response_code : 00 payment_certificate : 61b20c56df26 authorisation_id : 554166 currency_code : 978 card_number : 5217.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.winaudtumbach06 order_id : 15900 customer_email : j.winaudtumbach06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15901" select * from cms_frontusers where identifiant = "h.yvinec05" 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 = "15901" select * from cotisations where identifiant = "h.yvinec05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080950 payment_means : VISA transmission_date : 20161115070950 payment_time : 081151 payment_date : 20161115 response_code : 00 payment_certificate : c3145ed63852 authorisation_id : 676169 currency_code : 978 card_number : 4978.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.yvinec05 order_id : 15901 customer_email : h.yvinec05@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 = "15903" select * from cms_frontusers where identifiant = "m.jolivet19" 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 = "15903" select * from cotisations where identifiant = "m.jolivet19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090836 payment_means : MASTERCARD transmission_date : 20161115080836 payment_time : 091045 payment_date : 20161115 response_code : 00 payment_certificate : bc7a60962c75 authorisation_id : 289155 currency_code : 978 card_number : 5137.84 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.jolivet19 order_id : 15903 customer_email : m.jolivet19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15904" select * from cms_frontusers where identifiant = "d.chautard08" 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 = "15904" select * from cotisations where identifiant = "d.chautard08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094730 payment_means : VISA transmission_date : 20161115084730 payment_time : 094912 payment_date : 20161115 response_code : 00 payment_certificate : d5a81c34cc88 authorisation_id : 037665 currency_code : 978 card_number : 4970.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.chautard08 order_id : 15904 customer_email : d.chautard08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103417 payment_means : VISA transmission_date : 20161115093417 payment_time : 104218 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.tremblais12 order_id : 15905 customer_email : m.tremblais12@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 : 4000 transaction_id : 105217 payment_means : MASTERCARD transmission_date : 20161115095217 payment_time : 105712 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.54 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.scossabaggi30 order_id : 15906 customer_email : f.scossabaggi30@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15907" select * from cms_frontusers where identifiant = "e.blancmoreno15" 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 = "15907" select * from cotisations where identifiant = "e.blancmoreno15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110901 payment_means : VISA transmission_date : 20161115100901 payment_time : 111326 payment_date : 20161115 response_code : 00 payment_certificate : 8716ceb158be authorisation_id : 540406 currency_code : 978 card_number : 4454.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.blancmoreno15 order_id : 15907 customer_email : e.blancmoreno15@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 = "15908" select * from cms_frontusers where identifiant = "p.chapotet25" 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 = "15908" select * from cotisations where identifiant = "p.chapotet25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111541 payment_means : VISA transmission_date : 20161115101541 payment_time : 112135 payment_date : 20161115 response_code : 00 payment_certificate : 8fd38d9caf55 authorisation_id : 519406 currency_code : 978 card_number : 4970.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.chapotet25 order_id : 15908 customer_email : p.chapotet25@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 = "15909" select * from cms_frontusers where identifiant = "d.troutaudmazur11" 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 = "15909" select * from cotisations where identifiant = "d.troutaudmazur11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112040 payment_means : VISA transmission_date : 20161115102040 payment_time : 112146 payment_date : 20161115 response_code : 00 payment_certificate : 1cde681b72be authorisation_id : 443213 currency_code : 978 card_number : 4975.57 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.troutaudmazur11 order_id : 15909 customer_email : d.troutaudmazur11@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 = "15913" select * from cms_frontusers where identifiant = "j.guillotte13" 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 = "15913" select * from cotisations where identifiant = "j.guillotte13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112646 payment_means : MASTERCARD transmission_date : 20161115102646 payment_time : 112823 payment_date : 20161115 response_code : 00 payment_certificate : 7829c68b06ae authorisation_id : 536136 currency_code : 978 card_number : 5132.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.guillotte13 order_id : 15913 customer_email : j.guillotte13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 112600 payment_means : CB transmission_date : 20161115102600 payment_time : 112851 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.51 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 : m.fidalgo31 order_id : 15912 customer_email : m.fidalgo31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15916" select * from cms_frontusers where identifiant = "m.philippe13" 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 = "15916" select * from cotisations where identifiant = "m.philippe13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132346 payment_means : VISA transmission_date : 20161115122346 payment_time : 132612 payment_date : 20161115 response_code : 00 payment_certificate : eccf7bc3eeb9 authorisation_id : 093939 currency_code : 978 card_number : 4973.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.philippe13 order_id : 15916 customer_email : m.philippe13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15917" select * from cms_frontusers where identifiant = "t.math14" 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 = "15917" select * from cotisations where identifiant = "t.math14" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.math14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145721 payment_means : VISA transmission_date : 20161115135721 payment_time : 145908 payment_date : 20161115 response_code : 00 payment_certificate : 711aaa2685b0 authorisation_id : 331643 currency_code : 978 card_number : 4974.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.math14 order_id : 15917 customer_email : t.math14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15918" select * from cms_frontusers where identifiant = "y.mangold08" 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 = "15918" select * from cotisations where identifiant = "y.mangold08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153925 payment_means : MASTERCARD transmission_date : 20161115143925 payment_time : 154304 payment_date : 20161115 response_code : 00 payment_certificate : aa4df6f3c4c7 authorisation_id : 035714 currency_code : 978 card_number : 5132.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.mangold08 order_id : 15918 customer_email : y.mangold08@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 = "15919" select * from cms_frontusers where identifiant = "r.viault28" 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 = "15919" select * from cotisations where identifiant = "s.forget29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163754 payment_means : MASTERCARD transmission_date : 20161115153754 payment_time : 164145 payment_date : 20161115 response_code : 00 payment_certificate : 67220a6f5a1e authorisation_id : 895569 currency_code : 978 card_number : 5135.00 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.viault28 order_id : 15919 customer_email : r.viault28@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 = "15920" select * from cms_frontusers where identifiant = "r.viault28" 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 = "15920" select * from cotisations where identifiant = "j.soriano03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164246 payment_means : MASTERCARD transmission_date : 20161115154246 payment_time : 164420 payment_date : 20161115 response_code : 00 payment_certificate : 2878331e4fa3 authorisation_id : 596924 currency_code : 978 card_number : 5133.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.viault28 order_id : 15920 customer_email : r.viault28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15921" select * from cms_frontusers where identifiant = "r.viault28" 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 = "15921" select * from cotisations where identifiant = "ph.lalague15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164500 payment_means : MASTERCARD transmission_date : 20161115154500 payment_time : 164648 payment_date : 20161115 response_code : 00 payment_certificate : 364fdb82fe86 authorisation_id : 846611 currency_code : 978 card_number : 5137.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 : r.viault28 order_id : 15921 customer_email : r.viault28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15922" select * from cms_frontusers where identifiant = "y.rouch01" 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 = "15922" select * from cotisations where identifiant = "y.rouch01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170249 payment_means : MASTERCARD transmission_date : 20161115160249 payment_time : 170415 payment_date : 20161115 response_code : 00 payment_certificate : 54bc4daca5d0 authorisation_id : 464362 currency_code : 978 card_number : 5131.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.rouch01 order_id : 15922 customer_email : y.rouch01@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 = "15923" 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 = "15923" select * from cotisations where identifiant = "b.haerinck10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173533 payment_means : VISA transmission_date : 20161115163533 payment_time : 173817 payment_date : 20161115 response_code : 00 payment_certificate : 2c73f8e09993 authorisation_id : 212637 currency_code : 978 card_number : 4978.84 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.haeringer25 order_id : 15923 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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15924" select * from cms_frontusers where identifiant = "l.chranuski31" 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 = "15924" select * from cotisations where identifiant = "l.chranuski31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183329 payment_means : VISA transmission_date : 20161115173329 payment_time : 183438 payment_date : 20161115 response_code : 00 payment_certificate : fa6ca95c7488 authorisation_id : 008010 currency_code : 978 card_number : 4659.59 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.chranuski31 order_id : 15924 customer_email : l.chranuski31@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183534 payment_means : VISA transmission_date : 20161115173534 payment_time : 183731 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4698.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.chranuski31 order_id : 15925 customer_email : l.chranuski31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15926" select * from cms_frontusers where identifiant = "p.gouttefangeas13" 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 = "15926" select * from cotisations where identifiant = "p.gouttefangeas13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184310 payment_means : VISA transmission_date : 20161115174310 payment_time : 184548 payment_date : 20161115 response_code : 00 payment_certificate : 76fa5ed70f38 authorisation_id : 440383 currency_code : 978 card_number : 4976.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.gouttefangeas13 order_id : 15926 customer_email : p.gouttefangeas13@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 = "15927" select * from cms_frontusers where identifiant = "n.neret06" 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 = "15927" select * from cotisations where identifiant = "n.neret06" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "n.neret06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184727 payment_means : VISA transmission_date : 20161115174727 payment_time : 184919 payment_date : 20161115 response_code : 00 payment_certificate : 65bc4cc02792 authorisation_id : 027621 currency_code : 978 card_number : 4975.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.neret06 order_id : 15927 customer_email : n.neret06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184809 payment_means : MASTERCARD transmission_date : 20161115174809 payment_time : 184941 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.faravel29 order_id : 15929 customer_email : e.faravel29@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 : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15930" select * from cms_frontusers where identifiant = "b.seres21" 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 = "15930" select * from cotisations where identifiant = "b.seres21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185156 payment_means : MASTERCARD transmission_date : 20161115175156 payment_time : 185402 payment_date : 20161115 response_code : 00 payment_certificate : 39c16b3e54b2 authorisation_id : 179566 currency_code : 978 card_number : 5137.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 : b.seres21 order_id : 15930 customer_email : b.seres21@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 = "15932" select * from cms_frontusers where identifiant = "c.lebeau08" 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 = "15932" select * from cotisations where identifiant = "c.lebeau08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190152 payment_means : VISA transmission_date : 20161115180152 payment_time : 190307 payment_date : 20161115 response_code : 00 payment_certificate : 94c2c1170b6a authorisation_id : 486215 currency_code : 978 card_number : 4972.17 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.lebeau08 order_id : 15932 customer_email : c.lebeau08@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 = "15934" select * from cms_frontusers where identifiant = "g.allain16" 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 = "15934" select * from cotisations where identifiant = "g.allain16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190242 payment_means : MASTERCARD transmission_date : 20161115180242 payment_time : 190345 payment_date : 20161115 response_code : 00 payment_certificate : 14112f503e45 authorisation_id : 751751 currency_code : 978 card_number : 5137.57 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.allain16 order_id : 15934 customer_email : g.allain16@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 = "15933" select * from cms_frontusers where identifiant = "p.laviale06" 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 = "15933" select * from cotisations where identifiant = "p.laviale06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190422 payment_means : VISA transmission_date : 20161115180422 payment_time : 190745 payment_date : 20161115 response_code : 00 payment_certificate : 586b83f2e4c0 authorisation_id : 445469 currency_code : 978 card_number : 4973.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 : p.laviale06 order_id : 15933 customer_email : p.laviale06@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 : 191939 payment_means : MASTERCARD transmission_date : 20161115181939 payment_time : 192206 payment_date : 20161115 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 61 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : as.pouet26 order_id : 15936 customer_email : as.pouet26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192204 payment_means : VISA transmission_date : 20161115182204 payment_time : 192734 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.gres05 order_id : 15937 customer_email : g.gres05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192641 payment_means : MASTERCARD transmission_date : 20161115182641 payment_time : 193036 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5130.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.reissier21 order_id : 15938 customer_email : p.reissier21@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 : 201810 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 : 193901 payment_means : MASTERCARD transmission_date : 20161115183901 payment_time : 194110 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.lesourne23 order_id : 15940 customer_email : v.lesourne23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15941" select * from cms_frontusers where identifiant = "j.oliveira03" 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 = "15941" select * from cotisations where identifiant = "j.oliveira03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194047 payment_means : VISA transmission_date : 20161115184047 payment_time : 194311 payment_date : 20161115 response_code : 00 payment_certificate : 605f58592c40 authorisation_id : 644522 currency_code : 978 card_number : 4978.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 : j.oliveira03 order_id : 15941 customer_email : j.oliveira03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195220 payment_means : VISA transmission_date : 20161115185220 payment_time : 195511 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.gres05 order_id : 15942 customer_email : g.gres05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15944" select * from cms_frontusers where identifiant = "r.borrel22" 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 = "15944" select * from cotisations where identifiant = "r.borrel22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200303 payment_means : MASTERCARD transmission_date : 20161115190303 payment_time : 200459 payment_date : 20161115 response_code : 00 payment_certificate : 93cd13877722 authorisation_id : 504005 currency_code : 978 card_number : 5132.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.borrel22 order_id : 15944 customer_email : r.borrel22@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 = "15943" select * from cms_frontusers where identifiant = "a.claessens07" 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 = "15943" select * from cotisations where identifiant = "a.claessens07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200311 payment_means : VISA transmission_date : 20161115190311 payment_time : 200631 payment_date : 20161115 response_code : 00 payment_certificate : eaf7b6c1cc15 authorisation_id : 964224 currency_code : 978 card_number : 4970.78 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.claessens07 order_id : 15943 customer_email : a.claessens07@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 = "15946" select * from cms_frontusers where identifiant = "m.roche27" 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 = "15946" select * from cotisations where identifiant = "m.roche27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200616 payment_means : MASTERCARD transmission_date : 20161115190616 payment_time : 200715 payment_date : 20161115 response_code : 00 payment_certificate : cce37cd1fec2 authorisation_id : 791901 currency_code : 978 card_number : 5131.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.roche27 order_id : 15946 customer_email : m.roche27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201136 payment_means : VISA transmission_date : 20161115191136 payment_time : 201737 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4971.87 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.bartrieul17 order_id : 15947 customer_email : p.bartrieul17@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 : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15948" select * from cms_frontusers where identifiant = "m.biancalana03" 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 = "15948" select * from cotisations where identifiant = "m.biancalana03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201428 payment_means : MASTERCARD transmission_date : 20161115191428 payment_time : 201828 payment_date : 20161115 response_code : 00 payment_certificate : eb1c0667ab0d authorisation_id : 515537 currency_code : 978 card_number : 5132.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 : m.biancalana03 order_id : 15948 customer_email : m.biancalana03@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 = "15950" select * from cms_frontusers where identifiant = "k.woehrel01" 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 = "15950" select * from cotisations where identifiant = "k.woehrel01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201725 payment_means : MASTERCARD transmission_date : 20161115191725 payment_time : 201907 payment_date : 20161115 response_code : 00 payment_certificate : 7a2972aeb854 authorisation_id : 624127 currency_code : 978 card_number : 5132.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.woehrel01 order_id : 15950 customer_email : k.woehrel01@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 = "15951" select * from cms_frontusers where identifiant = "t.manson21" 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 = "15951" select * from cotisations where identifiant = "t.manson21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201825 payment_means : MASTERCARD transmission_date : 20161115191825 payment_time : 201940 payment_date : 20161115 response_code : 00 payment_certificate : 137b238ca582 authorisation_id : 555497 currency_code : 978 card_number : 5136.76 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.manson21 order_id : 15951 customer_email : t.manson21@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 : 202002 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15953" select * from cms_frontusers where identifiant = "m.germani11" 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 = "15953" select * from cotisations where identifiant = "m.germani11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201850 payment_means : VISA transmission_date : 20161115191850 payment_time : 202121 payment_date : 20161115 response_code : 00 payment_certificate : e4bfbe27907f authorisation_id : 228312 currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.germani11 order_id : 15953 customer_email : m.germani11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15959" select * from cms_frontusers where identifiant = "r.gazan20" 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 = "15959" select * from cotisations where identifiant = "r.gazan20" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "r.gazan20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202223 payment_means : VISA transmission_date : 20161115192223 payment_time : 202357 payment_date : 20161115 response_code : 00 payment_certificate : 10d36bbcf9c8 authorisation_id : 581630 currency_code : 978 card_number : 4973.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 : r.gazan20 order_id : 15959 customer_email : r.gazan20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15960" select * from cms_frontusers where identifiant = "p.barthes14" 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 = "15960" select * from cotisations where identifiant = "p.barthes14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202258 payment_means : VISA transmission_date : 20161115192258 payment_time : 202534 payment_date : 20161115 response_code : 00 payment_certificate : eeaa82d19645 authorisation_id : 625507 currency_code : 978 card_number : 4970.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 : p.barthes14 order_id : 15960 customer_email : p.barthes14@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 = "15961" select * from cms_frontusers where identifiant = "m.fresil28" 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 = "15961" select * from cotisations where identifiant = "m.fresil28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202353 payment_means : VISA transmission_date : 20161115192353 payment_time : 202600 payment_date : 20161115 response_code : 00 payment_certificate : d7957b6e238b authorisation_id : 211415 currency_code : 978 card_number : 4972.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.fresil28 order_id : 15961 customer_email : m.fresil28@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 = "15962" select * from cms_frontusers where identifiant = "m.pacquetet28" 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 = "15962" select * from cotisations where identifiant = "m.pacquetet28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202626 payment_means : MASTERCARD transmission_date : 20161115192626 payment_time : 202807 payment_date : 20161115 response_code : 00 payment_certificate : 9ff353d17a88 authorisation_id : 217316 currency_code : 978 card_number : 5136.05 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.pacquetet28 order_id : 15962 customer_email : m.pacquetet28@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 = "15952" select * from cms_frontusers where identifiant = "v.labadie17" 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 = "15952" select * from cotisations where identifiant = "v.labadie17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201917 payment_means : VISA transmission_date : 20161115191917 payment_time : 202849 payment_date : 20161115 response_code : 00 payment_certificate : d0e75d9ec803 authorisation_id : 046952 currency_code : 978 card_number : 4970.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.labadie17 order_id : 15952 customer_email : v.labadie17@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 = "15963" select * from cms_frontusers where identifiant = "jm.murgier20" 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 = "15963" select * from cotisations where identifiant = "jm.murgier20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202647 payment_means : VISA transmission_date : 20161115192647 payment_time : 203113 payment_date : 20161115 response_code : 00 payment_certificate : bc32f68f9406 authorisation_id : 245513 currency_code : 978 card_number : 4975.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 : jm.murgier20 order_id : 15963 customer_email : jm.murgier20@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 = "15965" select * from cms_frontusers where identifiant = "l.catapano20" 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 = "15965" select * from cotisations where identifiant = "l.catapano20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203244 payment_means : VISA transmission_date : 20161115193244 payment_time : 203426 payment_date : 20161115 response_code : 00 payment_certificate : 24734510afa2 authorisation_id : 662712 currency_code : 978 card_number : 4562.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.catapano20 order_id : 15965 customer_email : l.catapano20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15969" select * from cms_frontusers where identifiant = "a.mathevet28" 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 = "15969" select * from cotisations where identifiant = "p.leroy13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205037 payment_means : MASTERCARD transmission_date : 20161115195037 payment_time : 205209 payment_date : 20161115 response_code : 00 payment_certificate : 8fa9ac5be61d authorisation_id : 515363 currency_code : 978 card_number : 5131.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 : a.mathevet28 order_id : 15969 customer_email : a.mathevet28@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 = "15968" select * from cms_frontusers where identifiant = "j.fort07" 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 = "15968" select * from cotisations where identifiant = "j.fort07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205013 payment_means : VISA transmission_date : 20161115195013 payment_time : 205336 payment_date : 20161115 response_code : 00 payment_certificate : 275645e668a7 authorisation_id : 533942 currency_code : 978 card_number : 4978.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.fort07 order_id : 15968 customer_email : j.fort07@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 : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15970" select * from cms_frontusers where identifiant = "r.paugois20" 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 = "15970" select * from cotisations where identifiant = "r.paugois20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205051 payment_means : VISA transmission_date : 20161115195051 payment_time : 205422 payment_date : 20161115 response_code : 00 payment_certificate : 3849a3949d7f authorisation_id : 736536 currency_code : 978 card_number : 4978.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.paugois20 order_id : 15970 customer_email : r.paugois20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15971" select * from cms_frontusers where identifiant = "l.coiffard29" 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 = "15971" select * from cotisations where identifiant = "l.coiffard29" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "l.coiffard29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205914 payment_means : VISA transmission_date : 20161115195914 payment_time : 210239 payment_date : 20161115 response_code : 00 payment_certificate : 04c19e9dd3b3 authorisation_id : 212854 currency_code : 978 card_number : 4978.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.coiffard29 order_id : 15971 customer_email : l.coiffard29@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 = "15974" select * from cms_frontusers where identifiant = "z.mouhot25" 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 = "15974" select * from cotisations where identifiant = "z.mouhot25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210800 payment_means : MASTERCARD transmission_date : 20161115200800 payment_time : 210903 payment_date : 20161115 response_code : 00 payment_certificate : c145f8827b46 authorisation_id : 510036 currency_code : 978 card_number : 5130.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 : z.mouhot25 order_id : 15974 customer_email : z.mouhot25@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 = "15975" select * from cms_frontusers where identifiant = "g.mazeran12" 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 = "15975" select * from cotisations where identifiant = "g.mazeran12" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "g.mazeran12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210832 payment_means : MASTERCARD transmission_date : 20161115200832 payment_time : 211018 payment_date : 20161115 response_code : 00 payment_certificate : c1ecd7cf6cc9 authorisation_id : 262648 currency_code : 978 card_number : 5131.59 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.mazeran12 order_id : 15975 customer_email : g.mazeran12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15976" select * from cms_frontusers where identifiant = "r.maxant27" 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 = "15976" select * from cotisations where identifiant = "r.maxant27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211213 payment_means : VISA transmission_date : 20161115201213 payment_time : 211419 payment_date : 20161115 response_code : 00 payment_certificate : c904c75e296b authorisation_id : 864620 currency_code : 978 card_number : 4970.54 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.maxant27 order_id : 15976 customer_email : r.maxant27@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 : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15977" select * from cms_frontusers where identifiant = "e.proux23" 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 = "15977" select * from cotisations where identifiant = "e.proux23" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "e.proux23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211305 payment_means : VISA transmission_date : 20161115201305 payment_time : 211438 payment_date : 20161115 response_code : 00 payment_certificate : 302df029a2d9 authorisation_id : 421627 currency_code : 978 card_number : 4974.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 : e.proux23 order_id : 15977 customer_email : e.proux23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15982" select * from cms_frontusers where identifiant = "g.morel21" 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 = "15982" select * from cotisations where identifiant = "g.morel21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212016 payment_means : MASTERCARD transmission_date : 20161115202016 payment_time : 212221 payment_date : 20161115 response_code : 00 payment_certificate : 5c144bffd5a3 authorisation_id : 520823 currency_code : 978 card_number : 5131.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 : g.morel21 order_id : 15982 customer_email : g.morel21@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 = "15985" select * from cms_frontusers where identifiant = "b.labalette05" 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 = "15985" select * from cotisations where identifiant = "b.labalette05" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "b.labalette05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212155 payment_means : MASTERCARD transmission_date : 20161115202155 payment_time : 212326 payment_date : 20161115 response_code : 00 payment_certificate : f0b8253d07d6 authorisation_id : 152121 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 : b.labalette05 order_id : 15985 customer_email : b.labalette05@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 = "15984" select * from cms_frontusers where identifiant = "l.vincent20" 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 = "15984" select * from cotisations where identifiant = "l.vincent20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212137 payment_means : VISA transmission_date : 20161115202137 payment_time : 212342 payment_date : 20161115 response_code : 00 payment_certificate : 7ecabe5c0707 authorisation_id : 614466 currency_code : 978 card_number : 4977.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.vincent20 order_id : 15984 customer_email : l.vincent20@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 = "15986" select * from cms_frontusers where identifiant = "c.malarbet24" 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 = "15986" select * from cotisations where identifiant = "c.malarbet24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212238 payment_means : VISA transmission_date : 20161115202238 payment_time : 212426 payment_date : 20161115 response_code : 00 payment_certificate : add9c66c0d5d authorisation_id : 844358 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 : c.malarbet24 order_id : 15986 customer_email : c.malarbet24@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 = "15987" select * from cms_frontusers where identifiant = "l.ye10" 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 = "15987" select * from cotisations where identifiant = "l.ye10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212241 payment_means : MASTERCARD transmission_date : 20161115202241 payment_time : 212446 payment_date : 20161115 response_code : 00 payment_certificate : 03d4fd5a9ca5 authorisation_id : 739442 currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.ye10 order_id : 15987 customer_email : l.ye10@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 = "15988" select * from cms_frontusers where identifiant = "a.baltazar16" 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 = "15988" select * from cotisations where identifiant = "a.baltazar16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212308 payment_means : VISA transmission_date : 20161115202308 payment_time : 212615 payment_date : 20161115 response_code : 00 payment_certificate : 2f04c8d86322 authorisation_id : 912495 currency_code : 978 card_number : 4972.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.baltazar16 order_id : 15988 customer_email : a.baltazar16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15990" select * from cms_frontusers where identifiant = "r.winling17" 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 = "15990" select * from cotisations where identifiant = "r.winling17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212508 payment_means : MASTERCARD transmission_date : 20161115202508 payment_time : 212626 payment_date : 20161115 response_code : 00 payment_certificate : 8504e4c4f0f1 authorisation_id : 531963 currency_code : 978 card_number : 5132.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 : r.winling17 order_id : 15990 customer_email : r.winling17@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 = "15991" select * from cms_frontusers where identifiant = "t.deschamps10" 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 = "15991" select * from cotisations where identifiant = "t.deschamps10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212531 payment_means : MASTERCARD transmission_date : 20161115202531 payment_time : 212719 payment_date : 20161115 response_code : 00 payment_certificate : 40a2ed6cb650 authorisation_id : 119280 currency_code : 978 card_number : 5131.64 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.deschamps10 order_id : 15991 customer_email : t.deschamps10@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 = "15993" select * from cms_frontusers where identifiant = "m.nething12" 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 = "15993" select * from cotisations where identifiant = "m.nething12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213025 payment_means : MASTERCARD transmission_date : 20161115203025 payment_time : 213142 payment_date : 20161115 response_code : 00 payment_certificate : 4cbe53837779 authorisation_id : 128009 currency_code : 978 card_number : 5132.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.nething12 order_id : 15993 customer_email : m.nething12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15992" select * from cms_frontusers where identifiant = "t1.bonnin28" 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 = "15992" select * from cotisations where identifiant = "t1.bonnin28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212922 payment_means : VISA transmission_date : 20161115202922 payment_time : 213441 payment_date : 20161115 response_code : 00 payment_certificate : 2cb84a2d6534 authorisation_id : 512521 currency_code : 978 card_number : 4970.50 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t1.bonnin28 order_id : 15992 customer_email : t1.bonnin28@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15994" select * from cms_frontusers where identifiant = "j.guillaume06" 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 = "15994" select * from cotisations where identifiant = "j.guillaume06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213550 payment_means : VISA transmission_date : 20161115203550 payment_time : 213719 payment_date : 20161115 response_code : 00 payment_certificate : 388597d19586 authorisation_id : 161029 currency_code : 978 card_number : 4974.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.guillaume06 order_id : 15994 customer_email : j.guillaume06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15995" select * from cms_frontusers where identifiant = "t.felix16" 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 = "15995" select * from cotisations where identifiant = "t.felix16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213750 payment_means : VISA transmission_date : 20161115203750 payment_time : 213903 payment_date : 20161115 response_code : 00 payment_certificate : a75654e23e39 authorisation_id : 353524 currency_code : 978 card_number : 4978.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.felix16 order_id : 15995 customer_email : t.felix16@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 = "15996" select * from cms_frontusers where identifiant = "p.bartrieul17" 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 = "15996" select * from cotisations where identifiant = "p.bartrieul17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213942 payment_means : VISA transmission_date : 20161115203942 payment_time : 214544 payment_date : 20161115 response_code : 00 payment_certificate : 662d1ee27971 authorisation_id : 410330 currency_code : 978 card_number : 4971.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 : p.bartrieul17 order_id : 15996 customer_email : p.bartrieul17@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 = "15997" select * from cms_frontusers where identifiant = "g.ogier11" 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 = "15997" select * from cotisations where identifiant = "g.ogier11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214948 payment_means : VISA transmission_date : 20161115204948 payment_time : 215044 payment_date : 20161115 response_code : 00 payment_certificate : ac028710de2f authorisation_id : 255725 currency_code : 978 card_number : 4970.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 : g.ogier11 order_id : 15997 customer_email : g.ogier11@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 = "15999" select * from cms_frontusers where identifiant = "c.malarbet24" 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 = "15999" select * from cotisations where identifiant = "s.brault17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 215654 payment_means : VISA transmission_date : 20161115205654 payment_time : 215955 payment_date : 20161115 response_code : 00 payment_certificate : a24dd610e0bd authorisation_id : 696836 currency_code : 978 card_number : 4978.59 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.malarbet24 order_id : 15999 customer_email : c.malarbet24@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16000" select * from cms_frontusers where identifiant = "l.chranuski31" 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 = "16000" select * from cotisations where identifiant = "b.cabrol13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220201 payment_means : VISA transmission_date : 20161115210201 payment_time : 220403 payment_date : 20161115 response_code : 00 payment_certificate : e3b64f631b4e authorisation_id : 834627 currency_code : 978 card_number : 4698.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.chranuski31 order_id : 16000 customer_email : l.chranuski31@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 = "16001" select * from cms_frontusers where identifiant = "t.leone19" 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 = "16001" select * from cotisations where identifiant = "a.philibert17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221505 payment_means : VISA transmission_date : 20161115211505 payment_time : 221714 payment_date : 20161115 response_code : 00 payment_certificate : 530dc62dd5a6 authorisation_id : 046018 currency_code : 978 card_number : 4974.13 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.leone19 order_id : 16001 customer_email : t.leone19@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 : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16002" select * from cms_frontusers where identifiant = "c.lecoguiec22" 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 = "16002" select * from cotisations where identifiant = "c.lecoguiec22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221855 payment_means : VISA transmission_date : 20161115211855 payment_time : 222132 payment_date : 20161115 response_code : 00 payment_certificate : 8fa24a8a5982 authorisation_id : 883534 currency_code : 978 card_number : 4974.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 : c.lecoguiec22 order_id : 16002 customer_email : c.lecoguiec22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222049 payment_means : VISA transmission_date : 20161115212049 payment_time : 222616 payment_date : 20161115 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.buchi21 order_id : 16003 customer_email : a.buchi21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16004" select * from cms_frontusers where identifiant = "e.scarfiglieri16" 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 = "16004" select * from cotisations where identifiant = "e.scarfiglieri16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224234 payment_means : VISA transmission_date : 20161115214234 payment_time : 224427 payment_date : 20161115 response_code : 00 payment_certificate : c09e4d07ed3e authorisation_id : 251635 currency_code : 978 card_number : 4975.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.scarfiglieri16 order_id : 16004 customer_email : e.scarfiglieri16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224253 payment_means : VISA transmission_date : 20161115214253 payment_time : 224434 payment_date : 20161115 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.01 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 : p.augenstreich26 order_id : 16005 customer_email : p.augenstreich26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 225129 payment_means : VISA transmission_date : 20161115215129 payment_time : 225302 payment_date : 20161115 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.88 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.leone19 order_id : 16006 customer_email : t.leone19@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 : -------------------------------------------