select * from cotisations_commande where id = "16486" select * from cms_frontusers where identifiant = "d.schockaert14" 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 = "16486" select * from cotisations where identifiant = "d.schockaert14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 021634 payment_means : MASTERCARD transmission_date : 20161122011634 payment_time : 021836 payment_date : 20161122 response_code : 00 payment_certificate : 9a41919649dd authorisation_id : 248864 currency_code : 978 card_number : 5131.69 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.schockaert14 order_id : 16486 customer_email : d.schockaert14@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 = "16487" select * from cms_frontusers where identifiant = "b.fourquet29" 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 = "16487" select * from cotisations where identifiant = "b.fourquet29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 064718 payment_means : VISA transmission_date : 20161122054718 payment_time : 064908 payment_date : 20161122 response_code : 00 payment_certificate : 9d7c1c91b72f authorisation_id : 217546 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 : b.fourquet29 order_id : 16487 customer_email : b.fourquet29@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 = "16488" select * from cms_frontusers where identifiant = "j.roussinet07" 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 = "16488" select * from cotisations where identifiant = "j.roussinet07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071153 payment_means : VISA transmission_date : 20161122061153 payment_time : 071301 payment_date : 20161122 response_code : 00 payment_certificate : bc8093503694 authorisation_id : 999281 currency_code : 978 card_number : 4970.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.roussinet07 order_id : 16488 customer_email : j.roussinet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16489" select * from cms_frontusers where identifiant = "b.perdrier01" 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 = "16489" select * from cotisations where identifiant = "b.perdrier01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 072840 payment_means : VISA transmission_date : 20161122062840 payment_time : 073112 payment_date : 20161122 response_code : 00 payment_certificate : 430e0e08d123 authorisation_id : 441623 currency_code : 978 card_number : 4976.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.perdrier01 order_id : 16489 customer_email : b.perdrier01@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 = "16490" select * from cms_frontusers where identifiant = "s.desprez01" 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 = "16490" select * from cotisations where identifiant = "s.desprez01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081258 payment_means : MASTERCARD transmission_date : 20161122071258 payment_time : 081438 payment_date : 20161122 response_code : 00 payment_certificate : 6653067c52fb authorisation_id : 037365 currency_code : 978 card_number : 5136.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 : s.desprez01 order_id : 16490 customer_email : s.desprez01@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 = "16491" select * from cms_frontusers where identifiant = "s.desprez01" 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 = "16491" select * from cotisations where identifiant = "c.bietzer05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081617 payment_means : MASTERCARD transmission_date : 20161122071617 payment_time : 081806 payment_date : 20161122 response_code : 00 payment_certificate : 33b9489b67ef authorisation_id : 166222 currency_code : 978 card_number : 5136.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 : s.desprez01 order_id : 16491 customer_email : s.desprez01@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 = "16492" select * from cms_frontusers where identifiant = "pe.bris22" 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 = "16492" select * from cotisations where identifiant = "pe.bris22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083143 payment_means : VISA transmission_date : 20161122073143 payment_time : 083314 payment_date : 20161122 response_code : 00 payment_certificate : baa247716365 authorisation_id : 363364 currency_code : 978 card_number : 4973.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : pe.bris22 order_id : 16492 customer_email : pe.bris22@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 = "16493" select * from cms_frontusers where identifiant = "t.jedele15" 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 = "16493" select * from cotisations where identifiant = "t.jedele15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 083654 payment_means : MASTERCARD transmission_date : 20161122073654 payment_time : 083910 payment_date : 20161122 response_code : 00 payment_certificate : b6e25ab358d9 authorisation_id : 180744 currency_code : 978 card_number : 5539.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.jedele15 order_id : 16493 customer_email : t.jedele15@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093901 payment_means : MASTERCARD transmission_date : 20161122083901 payment_time : 094056 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.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 : c.teisseyre05 order_id : 16494 customer_email : c.teisseyre05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16495" select * from cms_frontusers where identifiant = "m.chaillot27" 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 = "16495" select * from cotisations where identifiant = "m.chaillot27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093936 payment_means : MASTERCARD transmission_date : 20161122083936 payment_time : 094327 payment_date : 20161122 response_code : 00 payment_certificate : ff0b58ff6bf1 authorisation_id : 310091 currency_code : 978 card_number : 5132.74 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.chaillot27 order_id : 16495 customer_email : m.chaillot27@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 = "16496" select * from cms_frontusers where identifiant = "e.goetz18" 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 = "16496" select * from cotisations where identifiant = "e.goetz18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102955 payment_means : VISA transmission_date : 20161122092955 payment_time : 103142 payment_date : 20161122 response_code : 00 payment_certificate : 0e7074684ab0 authorisation_id : 587334 currency_code : 978 card_number : 4975.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.goetz18 order_id : 16496 customer_email : e.goetz18@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 = "16497" select * from cms_frontusers where identifiant = "p.roturier25" 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 = "16497" select * from cotisations where identifiant = "p.roturier25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105700 payment_means : MASTERCARD transmission_date : 20161122095700 payment_time : 110032 payment_date : 20161122 response_code : 00 payment_certificate : 2d5672a3bc05 authorisation_id : 556542 currency_code : 978 card_number : 5137.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 : p.roturier25 order_id : 16497 customer_email : p.roturier25@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 = "16498" select * from cms_frontusers where identifiant = "g.pocquat10" 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 = "16498" select * from cotisations where identifiant = "g.pocquat10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113010 payment_means : MASTERCARD transmission_date : 20161122103010 payment_time : 113224 payment_date : 20161122 response_code : 00 payment_certificate : e628c1a77788 authorisation_id : 425461 currency_code : 978 card_number : 5137.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.pocquat10 order_id : 16498 customer_email : g.pocquat10@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 = "16499" select * from cms_frontusers where identifiant = "j.marechal27" 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 = "16499" select * from cotisations where identifiant = "l.rouhier24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114819 payment_means : VISA transmission_date : 20161122104819 payment_time : 115051 payment_date : 20161122 response_code : 00 payment_certificate : 481fc28685d2 authorisation_id : 215219 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 : j.marechal27 order_id : 16499 customer_email : j.marechal27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16501" select * from cms_frontusers where identifiant = "c.uzanne11" 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 = "16501" select * from cotisations where identifiant = "c.uzanne11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130142 payment_means : VISA transmission_date : 20161122120142 payment_time : 130426 payment_date : 20161122 response_code : 00 payment_certificate : cc6ab202e177 authorisation_id : 406454 currency_code : 978 card_number : 4978.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.uzanne11 order_id : 16501 customer_email : c.uzanne11@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 = "16502" select * from cms_frontusers where identifiant = "a.papin22" 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 = "16502" select * from cotisations where identifiant = "a.papin22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131330 payment_means : MASTERCARD transmission_date : 20161122121330 payment_time : 131647 payment_date : 20161122 response_code : 00 payment_certificate : 40ad6324c06c authorisation_id : 011583 currency_code : 978 card_number : 5132.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.papin22 order_id : 16502 customer_email : a.papin22@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 = "16503" select * from cms_frontusers where identifiant = "t.claparede10" 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 = "16503" select * from cotisations where identifiant = "t.claparede10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132301 payment_means : VISA transmission_date : 20161122122301 payment_time : 132359 payment_date : 20161122 response_code : 00 payment_certificate : 20e5e4f2e1f9 authorisation_id : 411353 currency_code : 978 card_number : 4972.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 : t.claparede10 order_id : 16503 customer_email : t.claparede10@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 = "16506" select * from cms_frontusers where identifiant = "s.caulier08" 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 = "16506" select * from cotisations where identifiant = "s.caulier08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133536 payment_means : VISA transmission_date : 20161122123536 payment_time : 133656 payment_date : 20161122 response_code : 00 payment_certificate : 0731ae07a9aa authorisation_id : 648442 currency_code : 978 card_number : 4977.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.caulier08 order_id : 16506 customer_email : s.caulier08@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 = "16504" select * from cms_frontusers where identifiant = "k.thebaud10" 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 = "16504" select * from cotisations where identifiant = "k.thebaud10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133409 payment_means : MASTERCARD transmission_date : 20161122123409 payment_time : 133705 payment_date : 20161122 response_code : 00 payment_certificate : 868fa73ba1f7 authorisation_id : 629578 currency_code : 978 card_number : 5137.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.thebaud10 order_id : 16504 customer_email : k.thebaud10@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 = "16505" select * from cms_frontusers where identifiant = "c.chene12" 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 = "16505" select * from cotisations where identifiant = "c.chene12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 133518 payment_means : VISA transmission_date : 20161122123518 payment_time : 133748 payment_date : 20161122 response_code : 00 payment_certificate : 2ee3694540db authorisation_id : 415223 currency_code : 978 card_number : 4975.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.chene12 order_id : 16505 customer_email : c.chene12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16507" select * from cms_frontusers where identifiant = "g.bello14" 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 = "16507" select * from cotisations where identifiant = "g.bello14" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "g.bello14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 133704 payment_means : VISA transmission_date : 20161122123704 payment_time : 133915 payment_date : 20161122 response_code : 00 payment_certificate : a3234505c0f8 authorisation_id : 877395 currency_code : 978 card_number : 4972.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 : g.bello14 order_id : 16507 customer_email : g.bello14@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 = "16508" select * from cms_frontusers where identifiant = "t.beauvillain12" 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 = "16508" select * from cotisations where identifiant = "t.beauvillain12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 140339 payment_means : MASTERCARD transmission_date : 20161122130339 payment_time : 140658 payment_date : 20161122 response_code : 00 payment_certificate : 82b2d405ff5c authorisation_id : 432744 currency_code : 978 card_number : 5132.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 : t.beauvillain12 order_id : 16508 customer_email : t.beauvillain12@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 = "16510" select * from cms_frontusers where identifiant = "v.arnaud10" 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 = "16510" select * from cotisations where identifiant = "v.arnaud10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 152427 payment_means : VISA transmission_date : 20161122142427 payment_time : 152716 payment_date : 20161122 response_code : 00 payment_certificate : 02ddca03e978 authorisation_id : 540421 currency_code : 978 card_number : 4978.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.arnaud10 order_id : 16510 customer_email : v.arnaud10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16511" select * from cms_frontusers where identifiant = "c.chouin27" 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 = "16511" select * from cotisations where identifiant = "c.chouin27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160118 payment_means : VISA transmission_date : 20161122150118 payment_time : 160241 payment_date : 20161122 response_code : 00 payment_certificate : ce67369c9a02 authorisation_id : 511520 currency_code : 978 card_number : 4970.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.chouin27 order_id : 16511 customer_email : c.chouin27@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 = "16512" select * from cms_frontusers where identifiant = "j.daune28" 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 = "16512" select * from cotisations where identifiant = "j.daune28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 160710 payment_means : VISA transmission_date : 20161122150710 payment_time : 160933 payment_date : 20161122 response_code : 00 payment_certificate : 1b92e2fe9509 authorisation_id : 291190 currency_code : 978 card_number : 4978.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 : j.daune28 order_id : 16512 customer_email : j.daune28@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 = "16514" select * from cms_frontusers where identifiant = "m.rougeron27" 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 = "16514" select * from cotisations where identifiant = "m.rougeron27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 163655 payment_means : MASTERCARD transmission_date : 20161122153655 payment_time : 163902 payment_date : 20161122 response_code : 00 payment_certificate : 205e74ff08fc authorisation_id : 682172 currency_code : 978 card_number : 5341.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.rougeron27 order_id : 16514 customer_email : m.rougeron27@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 = "16515" select * from cms_frontusers where identifiant = "l.pesenti23" 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 = "16515" select * from cotisations where identifiant = "l.pesenti23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164407 payment_means : MASTERCARD transmission_date : 20161122154407 payment_time : 164547 payment_date : 20161122 response_code : 00 payment_certificate : 4390af928a34 authorisation_id : 439351 currency_code : 978 card_number : 5137.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.pesenti23 order_id : 16515 customer_email : l.pesenti23@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 = "16516" select * from cms_frontusers where identifiant = "r.drouet10" 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 = "16516" select * from cotisations where identifiant = "r.drouet10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174218 payment_means : VISA transmission_date : 20161122164218 payment_time : 182043 payment_date : 20161122 response_code : 00 payment_certificate : ecc23ff04773 authorisation_id : 791185 currency_code : 978 card_number : 4978.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.drouet10 order_id : 16516 customer_email : r.drouet10@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 = "16518" select * from cms_frontusers where identifiant = "p.servy11" 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 = "16518" select * from cotisations where identifiant = "p.servy11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184126 payment_means : VISA transmission_date : 20161122174126 payment_time : 184403 payment_date : 20161122 response_code : 00 payment_certificate : 3137b95ff540 authorisation_id : 624346 currency_code : 978 card_number : 4975.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.servy11 order_id : 16518 customer_email : p.servy11@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 = "16520" select * from cms_frontusers where identifiant = "a.madoulaud13" 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 = "16520" select * from cotisations where identifiant = "a.madoulaud13" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.madoulaud13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184544 payment_means : MASTERCARD transmission_date : 20161122174544 payment_time : 184656 payment_date : 20161122 response_code : 00 payment_certificate : 7a5ac09a7b14 authorisation_id : 505662 currency_code : 978 card_number : 5136.90 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.madoulaud13 order_id : 16520 customer_email : a.madoulaud13@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 48000 transaction_id : 192217 payment_means : MASTERCARD transmission_date : 20161122182217 payment_time : 192353 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5400.82 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.jarantowski25 order_id : 16523 customer_email : p.jarantowski25@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 : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16522" select * from cms_frontusers where identifiant = "g.perrin16" 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 = "16522" select * from cotisations where identifiant = "g.perrin16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192137 payment_means : VISA transmission_date : 20161122182137 payment_time : 192811 payment_date : 20161122 response_code : 00 payment_certificate : 9ecac7f2d928 authorisation_id : 571796 currency_code : 978 card_number : 4978.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 : g.perrin16 order_id : 16522 customer_email : g.perrin16@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 = "16524" select * from cms_frontusers where identifiant = "m.andre18" 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 = "16524" select * from cotisations where identifiant = "m.andre18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 5000 transaction_id : 194103 payment_means : VISA transmission_date : 20161122184103 payment_time : 194158 payment_date : 20161122 response_code : 00 payment_certificate : bdb7638d8c03 authorisation_id : 562883 currency_code : 978 card_number : 4059.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.andre18 order_id : 16524 customer_email : m.andre18@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 = "16525" select * from cms_frontusers where identifiant = "d.tempia10" 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 = "16525" select * from cotisations where identifiant = "d.tempia10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200118 payment_means : MASTERCARD transmission_date : 20161122190118 payment_time : 200356 payment_date : 20161122 response_code : 00 payment_certificate : 13a51381421f authorisation_id : 434225 currency_code : 978 card_number : 5137.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 : d.tempia10 order_id : 16525 customer_email : d.tempia10@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 = "16527" select * from cms_frontusers where identifiant = "q.remize11" 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 = "16527" select * from cotisations where identifiant = "q.remize11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200751 payment_means : MASTERCARD transmission_date : 20161122190751 payment_time : 200927 payment_date : 20161122 response_code : 00 payment_certificate : 656ee938638f authorisation_id : 886502 currency_code : 978 card_number : 5137.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 : q.remize11 order_id : 16527 customer_email : q.remize11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16528" select * from cms_frontusers where identifiant = "f.neny08" 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 = "16528" select * from cotisations where identifiant = "f.neny08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201241 payment_means : VISA transmission_date : 20161122191241 payment_time : 201359 payment_date : 20161122 response_code : 00 payment_certificate : befe1c913a48 authorisation_id : 124753 currency_code : 978 card_number : 4974.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 : f.neny08 order_id : 16528 customer_email : f.neny08@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 = "16531" select * from cms_frontusers where identifiant = "a.tranchard02" 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 = "16531" select * from cotisations where identifiant = "a.tranchard02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202610 payment_means : MASTERCARD transmission_date : 20161122192610 payment_time : 202809 payment_date : 20161122 response_code : 00 payment_certificate : 511b3dd30e95 authorisation_id : 114254 currency_code : 978 card_number : 5131.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 : a.tranchard02 order_id : 16531 customer_email : a.tranchard02@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202356 payment_means : VISA transmission_date : 20161122192356 payment_time : 203236 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.71 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.kamenetzky23 order_id : 16530 customer_email : a.kamenetzky23@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 : 203152 payment_means : MASTERCARD transmission_date : 20161122193152 payment_time : 203406 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.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 : b.guinard26 order_id : 16532 customer_email : b.guinard26@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 = "16533" select * from cms_frontusers where identifiant = "g.guimier28" 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 = "16533" select * from cotisations where identifiant = "g.guimier28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204114 payment_means : VISA transmission_date : 20161122194114 payment_time : 204423 payment_date : 20161122 response_code : 00 payment_certificate : 7af4f836994c authorisation_id : 289191 currency_code : 978 card_number : 4978.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.guimier28 order_id : 16533 customer_email : g.guimier28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210539 payment_means : MASTERCARD transmission_date : 20161122200539 payment_time : 210804 payment_date : 20161122 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.allongue14 order_id : 16535 customer_email : d.allongue14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16536" select * from cms_frontusers where identifiant = "p.lemaire20" 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 = "16536" select * from cotisations where identifiant = "p.lemaire20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210742 payment_means : VISA transmission_date : 20161122200742 payment_time : 210845 payment_date : 20161122 response_code : 00 payment_certificate : 1dae183e6bdc authorisation_id : 616258 currency_code : 978 card_number : 4978.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.lemaire20 order_id : 16536 customer_email : p.lemaire20@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 = "16538" select * from cms_frontusers where identifiant = "t.colon19" 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 = "16538" select * from cotisations where identifiant = "t.colon19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211746 payment_means : VISA transmission_date : 20161122201746 payment_time : 211919 payment_date : 20161122 response_code : 00 payment_certificate : 24c193cc4af3 authorisation_id : 234547 currency_code : 978 card_number : 4973.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 : t.colon19 order_id : 16538 customer_email : t.colon19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16540" select * from cms_frontusers where identifiant = "c.perrigot04" 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 = "16540" select * from cotisations where identifiant = "c.perrigot04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211913 payment_means : MASTERCARD transmission_date : 20161122201913 payment_time : 212107 payment_date : 20161122 response_code : 00 payment_certificate : bfb256003668 authorisation_id : 536815 currency_code : 978 card_number : 5133.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.perrigot04 order_id : 16540 customer_email : c.perrigot04@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 = "16543" select * from cms_frontusers where identifiant = "t.colon19" 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 = "16543" select * from cotisations where identifiant = "m.bauer02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 212110 payment_means : VISA transmission_date : 20161122202110 payment_time : 212205 payment_date : 20161122 response_code : 00 payment_certificate : 76c3299abe47 authorisation_id : 244651 currency_code : 978 card_number : 4973.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 : t.colon19 order_id : 16543 customer_email : t.colon19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16539" select * from cms_frontusers where identifiant = "l.panas25" 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 = "16539" select * from cotisations where identifiant = "l.panas25" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "l.panas25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211853 payment_means : MASTERCARD transmission_date : 20161122201853 payment_time : 212224 payment_date : 20161122 response_code : 00 payment_certificate : b43901576f78 authorisation_id : 157860 currency_code : 978 card_number : 5137.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 : l.panas25 order_id : 16539 customer_email : l.panas25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16537" select * from cms_frontusers where identifiant = "t.barthelemy03" 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 = "16537" select * from cotisations where identifiant = "t.barthelemy03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212021 payment_means : MASTERCARD transmission_date : 20161122202021 payment_time : 212227 payment_date : 20161122 response_code : 00 payment_certificate : 0c4c7e4a4470 authorisation_id : 360560 currency_code : 978 card_number : 5135.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.barthelemy03 order_id : 16537 customer_email : t.barthelemy03@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 = "16542" select * from cms_frontusers where identifiant = "a.blaszczyk04" 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 = "16542" select * from cotisations where identifiant = "a.mangniers13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212026 payment_means : VISA transmission_date : 20161122202026 payment_time : 212247 payment_date : 20161122 response_code : 00 payment_certificate : 94f219ac0975 authorisation_id : 492211 currency_code : 978 card_number : 4970.98 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.blaszczyk04 order_id : 16542 customer_email : a.blaszczyk04@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 : 4000 transaction_id : 212115 payment_means : MASTERCARD transmission_date : 20161122202115 payment_time : 212335 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.pezot25 order_id : 16544 customer_email : n.pezot25@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 : 201801 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 : 212215 payment_means : MASTERCARD transmission_date : 20161122202215 payment_time : 212358 payment_date : 20161122 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.93 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 : r.winling17 order_id : 16545 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 : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16548" select * from cms_frontusers where identifiant = "a.blaszczyk04" 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 = "16548" select * from cotisations where identifiant = "j.piazza13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212917 payment_means : MASTERCARD transmission_date : 20161122202917 payment_time : 213049 payment_date : 20161122 response_code : 00 payment_certificate : e7eced855eb6 authorisation_id : 306859 currency_code : 978 card_number : 5131.22 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.blaszczyk04 order_id : 16548 customer_email : a.blaszczyk04@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 : 4000 transaction_id : 213636 payment_means : VISA transmission_date : 20161122203636 payment_time : 214137 payment_date : 20161122 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.59 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 : b.goux28 order_id : 16549 customer_email : b.goux28@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 : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16551" select * from cms_frontusers where identifiant = "t.besnier13" 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 = "16551" select * from cotisations where identifiant = "t.besnier13" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214026 payment_means : MASTERCARD transmission_date : 20161122204026 payment_time : 214209 payment_date : 20161122 response_code : 00 payment_certificate : 2e540fb1772a authorisation_id : 124100 currency_code : 978 card_number : 5132.61 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.besnier13 order_id : 16551 customer_email : t.besnier13@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 = "16549" select * from cms_frontusers where identifiant = "b.goux28" 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 = "16549" select * from cotisations where identifiant = "b.goux28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 214143 payment_means : VISA transmission_date : 20161122204143 payment_time : 214359 payment_date : 20161122 response_code : 00 payment_certificate : cb803d1bd281 authorisation_id : 542152 currency_code : 978 card_number : 4973.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 : b.goux28 order_id : 16549 customer_email : b.goux28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16552" select * from cms_frontusers where identifiant = "d.rolland16" 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 = "16552" select * from cotisations where identifiant = "q.bellounat16" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "q.bellounat16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 215702 payment_means : VISA transmission_date : 20161122205702 payment_time : 220049 payment_date : 20161122 response_code : 00 payment_certificate : e532039703d6 authorisation_id : 356131 currency_code : 978 card_number : 4975.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 : d.rolland16 order_id : 16552 customer_email : d.rolland16@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 = "16555" select * from cms_frontusers where identifiant = "f.drapeau11" 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 = "16555" select * from cotisations where identifiant = "j.charbonneau19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222016 payment_means : MASTERCARD transmission_date : 20161122212016 payment_time : 222201 payment_date : 20161122 response_code : 00 payment_certificate : dca800de4d9f authorisation_id : 413944 currency_code : 978 card_number : 5132.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 : f.drapeau11 order_id : 16555 customer_email : f.drapeau11@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 = "16554" select * from cms_frontusers where identifiant = "j.lecalve28" 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 = "16554" select * from cotisations where identifiant = "j.lecalve28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221854 payment_means : MASTERCARD transmission_date : 20161122211854 payment_time : 222230 payment_date : 20161122 response_code : 00 payment_certificate : 8b6868766616 authorisation_id : 213725 currency_code : 978 card_number : 5137.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.lecalve28 order_id : 16554 customer_email : j.lecalve28@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 = "16556" select * from cms_frontusers where identifiant = "a.seitz20" 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 = "16556" select * from cotisations where identifiant = "jl.testevuide10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222317 payment_means : MASTERCARD transmission_date : 20161122212317 payment_time : 222422 payment_date : 20161122 response_code : 00 payment_certificate : 3e967134fd67 authorisation_id : 214593 currency_code : 978 card_number : 5137.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 : a.seitz20 order_id : 16556 customer_email : a.seitz20@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 = "16557" select * from cms_frontusers where identifiant = "d.bourotte19" 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 = "16557" select * from cotisations where identifiant = "d.bourotte19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222348 payment_means : VISA transmission_date : 20161122212348 payment_time : 222608 payment_date : 20161122 response_code : 00 payment_certificate : e0ce8fab43d1 authorisation_id : 546566 currency_code : 978 card_number : 4978.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.bourotte19 order_id : 16557 customer_email : d.bourotte19@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 = "16558" select * from cms_frontusers where identifiant = "d.bourotte19" 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 = "16558" select * from cotisations where identifiant = "d.bourotte19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222746 payment_means : VISA transmission_date : 20161122212746 payment_time : 223033 payment_date : 20161122 response_code : 00 payment_certificate : dd6af4955a3a authorisation_id : 013343 currency_code : 978 card_number : 4978.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.bourotte19 order_id : 16558 customer_email : d.bourotte19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 230648 payment_means : MASTERCARD transmission_date : 20161122220648 payment_time : 230801 payment_date : 20161122 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.22 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 : j.leger04 order_id : 16559 customer_email : j.leger04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16560" select * from cms_frontusers where identifiant = "m.medeville05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "16560" select * from cotisations where identifiant = "m.medeville05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 231801 payment_means : VISA transmission_date : 20161122221801 payment_time : 231940 payment_date : 20161122 response_code : 00 payment_certificate : 69e37800c6ba authorisation_id : 726441 currency_code : 978 card_number : 4976.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.medeville05 order_id : 16560 customer_email : m.medeville05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "16561" select * from cms_frontusers where identifiant = "da.martelmorin05" 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 = "16561" select * from cotisations where identifiant = "da.martelmorin05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 232025 payment_means : MASTERCARD transmission_date : 20161122222025 payment_time : 232143 payment_date : 20161122 response_code : 00 payment_certificate : 2de252032854 authorisation_id : 164138 currency_code : 978 card_number : 5131.08 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 : da.martelmorin05 order_id : 16561 customer_email : da.martelmorin05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------