Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 015018 payment_means : VISA transmission_date : 20151114005018 payment_time : 015531 payment_date : 20151114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.17 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 : a.xolin30 order_id : 8888 customer_email : a.xolin30@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 015540 payment_means : MASTERCARD transmission_date : 20151114005540 payment_time : 015743 payment_date : 20151114 response_code : 34 payment_certificate : authorisation_id : 887010 currency_code : 978 card_number : 5136.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 34 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.xolin30 order_id : 8888 customer_email : a.xolin30@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 = "8889" select * from cms_frontusers where identifiant = "g.juhasz05" 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 = "8889" select * from cotisations where identifiant = "g.juhasz05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071608 payment_means : MASTERCARD transmission_date : 20151114061608 payment_time : 071931 payment_date : 20151114 response_code : 00 payment_certificate : 87a682fec11b authorisation_id : 644355 currency_code : 978 card_number : 5131.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 : g.juhasz05 order_id : 8889 customer_email : g.juhasz05@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 = "8890" select * from cms_frontusers where identifiant = "jl.mouezy16" 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 = "8890" select * from cotisations where identifiant = "jl.mouezy16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082301 payment_means : VISA transmission_date : 20151114072301 payment_time : 082832 payment_date : 20151114 response_code : 00 payment_certificate : 91464b965454 authorisation_id : 550737 currency_code : 978 card_number : 4977.89 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.mouezy16 order_id : 8890 customer_email : jl.mouezy16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8891" select * from cms_frontusers where identifiant = "v.payn11" 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 = "8891" select * from cotisations where identifiant = "v.payn11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 084538 payment_means : MASTERCARD transmission_date : 20151114074538 payment_time : 084830 payment_date : 20151114 response_code : 00 payment_certificate : 603d366b5d67 authorisation_id : 214251 currency_code : 978 card_number : 5132.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 : v.payn11 order_id : 8891 customer_email : v.payn11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090214 payment_means : VISA transmission_date : 20151114080214 payment_time : 090658 payment_date : 20151114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.15 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 : d.bourdy23 order_id : 8893 customer_email : d.bourdy23@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8894" select * from cms_frontusers where identifiant = "n.pinet18" 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 = "8894" select * from cotisations where identifiant = "n.pinet18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090730 payment_means : MASTERCARD transmission_date : 20151114080730 payment_time : 090907 payment_date : 20151114 response_code : 00 payment_certificate : ffa58d621d03 authorisation_id : 311268 currency_code : 978 card_number : 5341.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 : n.pinet18 order_id : 8894 customer_email : n.pinet18@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 : 8000 transaction_id : 090704 payment_means : VISA transmission_date : 20151114080704 payment_time : 090908 payment_date : 20151114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.36 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 : d.bourdy23 order_id : 8893 customer_email : d.bourdy23@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 : ------------------------------------------- select * from cotisations_commande where id = "8895" select * from cms_frontusers where identifiant = "m.adam29" 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 = "8895" select * from cotisations where identifiant = "m.adam29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091012 payment_means : MASTERCARD transmission_date : 20151114081012 payment_time : 091209 payment_date : 20151114 response_code : 00 payment_certificate : 8a889072a96a authorisation_id : 166492 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 : m.adam29 order_id : 8895 customer_email : m.adam29@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 = "8896" select * from cms_frontusers where identifiant = "m.adam29" 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 = "8896" select * from cotisations where identifiant = "f.camus25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091433 payment_means : VISA transmission_date : 20151114081433 payment_time : 091601 payment_date : 20151114 response_code : 00 payment_certificate : c57b3a2fc0d9 authorisation_id : 415094 currency_code : 978 card_number : 4970.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 : m.adam29 order_id : 8896 customer_email : m.adam29@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 = "8898" select * from cms_frontusers where identifiant = "m.adam29" 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 = "8898" select * from cotisations where identifiant = "c.nunes02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092718 payment_means : VISA transmission_date : 20151114082718 payment_time : 092904 payment_date : 20151114 response_code : 00 payment_certificate : fa2c911c8533 authorisation_id : 366461 currency_code : 978 card_number : 4974.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 : m.adam29 order_id : 8898 customer_email : m.adam29@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 = "8899" select * from cms_frontusers where identifiant = "m.adam29" 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 = "8899" select * from cotisations where identifiant = "l.poiret27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093330 payment_means : VISA transmission_date : 20151114083330 payment_time : 093528 payment_date : 20151114 response_code : 00 payment_certificate : 56955657a62b authorisation_id : 951347 currency_code : 978 card_number : 4978.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 : m.adam29 order_id : 8899 customer_email : m.adam29@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 = "8900" select * from cms_frontusers where identifiant = "m.adam29" 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 = "8900" select * from cotisations where identifiant = "b.clement10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093822 payment_means : VISA transmission_date : 20151114083822 payment_time : 093920 payment_date : 20151114 response_code : 00 payment_certificate : f70af2b44778 authorisation_id : 261056 currency_code : 978 card_number : 4978.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 : m.adam29 order_id : 8900 customer_email : m.adam29@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 = "8901" select * from cms_frontusers where identifiant = "f.goilot23" 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 = "8901" select * from cotisations where identifiant = "f.goilot23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101338 payment_means : VISA transmission_date : 20151114091338 payment_time : 101808 payment_date : 20151114 response_code : 00 payment_certificate : 358f884bba38 authorisation_id : 221466 currency_code : 978 card_number : 4977.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 : f.goilot23 order_id : 8901 customer_email : f.goilot23@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 = "8903" 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 = "8903" select * from cotisations where identifiant = "r.winling17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103501 payment_means : MASTERCARD transmission_date : 20151114093501 payment_time : 103834 payment_date : 20151114 response_code : 00 payment_certificate : 3c63270c149b authorisation_id : 825352 currency_code : 978 card_number : 5132.91 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 : 8903 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 : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8904" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8904" select * from cotisations where identifiant = "pj.guillaume23" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "pj.guillaume23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 103829 payment_means : VISA transmission_date : 20151114093829 payment_time : 103932 payment_date : 20151114 response_code : 00 payment_certificate : e4dc260312bb authorisation_id : 424945 currency_code : 978 card_number : 4974.58 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8904 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8902" select * from cms_frontusers where identifiant = "cf.bonnet10" 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 = "8902" select * from cotisations where identifiant = "s.bouillon08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103346 payment_means : MASTERCARD transmission_date : 20151114093346 payment_time : 104055 payment_date : 20151114 response_code : 00 payment_certificate : c4ecd4cbd499 authorisation_id : 757661 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 : cf.bonnet10 order_id : 8902 customer_email : cf.bonnet10@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 = "8907" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8907" select * from cotisations where identifiant = "a.gaudin16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104410 payment_means : VISA transmission_date : 20151114094410 payment_time : 104449 payment_date : 20151114 response_code : 00 payment_certificate : 9fc4d0ade185 authorisation_id : 486856 currency_code : 978 card_number : 4974.35 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8907 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201607 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8906" select * from cms_frontusers where identifiant = "l.martin11" 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 = "8906" select * from cotisations where identifiant = "l.martin11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104321 payment_means : MASTERCARD transmission_date : 20151114094321 payment_time : 104456 payment_date : 20151114 response_code : 00 payment_certificate : b159c42c53d6 authorisation_id : 522454 currency_code : 978 card_number : 5131.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 : l.martin11 order_id : 8906 customer_email : l.martin11@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 = "8908" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8908" select * from cotisations where identifiant = "j.fouquet03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105751 payment_means : VISA transmission_date : 20151114095751 payment_time : 105903 payment_date : 20151114 response_code : 00 payment_certificate : ffa0f2d907a9 authorisation_id : 050255 currency_code : 978 card_number : 4974.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 : a.gaudin16 order_id : 8908 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8911" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8911" select * from cotisations where identifiant = "o.platz30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110420 payment_means : MASTERCARD transmission_date : 20151114100420 payment_time : 110543 payment_date : 20151114 response_code : 00 payment_certificate : 7f354f203147 authorisation_id : 241969 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 : a.gaudin16 order_id : 8911 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8912" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8912" select * from cotisations where identifiant = "j.passelande26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110654 payment_means : VISA transmission_date : 20151114100654 payment_time : 110828 payment_date : 20151114 response_code : 00 payment_certificate : 390f7d4bb0f1 authorisation_id : 168863 currency_code : 978 card_number : 4970.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 : a.gaudin16 order_id : 8912 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8913" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8913" select * from cotisations where identifiant = "y.sengier10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110957 payment_means : MASTERCARD transmission_date : 20151114100957 payment_time : 111139 payment_date : 20151114 response_code : 00 payment_certificate : ec73371e286d authorisation_id : 738464 currency_code : 978 card_number : 5131.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8913 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8914" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8914" select * from cotisations where identifiant = "r.storez07" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "s.comte08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 111341 payment_means : MASTERCARD transmission_date : 20151114101341 payment_time : 111458 payment_date : 20151114 response_code : 00 payment_certificate : b9ecd239a54c authorisation_id : 405671 currency_code : 978 card_number : 5137.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8914 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8915" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8915" select * from cotisations where identifiant = "d.hallouin10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111723 payment_means : VISA transmission_date : 20151114101723 payment_time : 111856 payment_date : 20151114 response_code : 00 payment_certificate : 443025001763 authorisation_id : 412215 currency_code : 978 card_number : 4977.77 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8915 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8916" select * from cms_frontusers where identifiant = "j.eckstein30" 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 = "8916" select * from cotisations where identifiant = "j.eckstein30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 111741 payment_means : VISA transmission_date : 20151114101741 payment_time : 112005 payment_date : 20151114 response_code : 00 payment_certificate : bf8eb126e104 authorisation_id : 362551 currency_code : 978 card_number : 4978.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 : j.eckstein30 order_id : 8916 customer_email : j.eckstein30@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 = "8917" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8917" select * from cotisations where identifiant = "p.lerouxel12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112339 payment_means : VISA transmission_date : 20151114102339 payment_time : 112454 payment_date : 20151114 response_code : 00 payment_certificate : 1617353ef5de authorisation_id : 571791 currency_code : 978 card_number : 4973.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8917 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8918" select * from cms_frontusers where identifiant = "l.mackowiak04" 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 = "8918" select * from cotisations where identifiant = "l.mackowiak04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 113524 payment_means : VISA transmission_date : 20151114103524 payment_time : 113754 payment_date : 20151114 response_code : 00 payment_certificate : 49fbc4bc757b authorisation_id : 141966 currency_code : 978 card_number : 4975.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 : l.mackowiak04 order_id : 8918 customer_email : l.mackowiak04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 113705 payment_means : VISA transmission_date : 20151114103705 payment_time : 113801 payment_date : 20151114 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.35 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 : a.gaudin16 order_id : 8919 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201607 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 : 16000 transaction_id : 113824 payment_means : VISA transmission_date : 20151114103824 payment_time : 114021 payment_date : 20151114 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.35 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 : a.gaudin16 order_id : 8919 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201607 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8920" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8920" select * from cotisations where identifiant = "m.roth09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114209 payment_means : MASTERCARD transmission_date : 20151114104209 payment_time : 114325 payment_date : 20151114 response_code : 00 payment_certificate : b8f99e81c414 authorisation_id : 610266 currency_code : 978 card_number : 5132.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gaudin16 order_id : 8920 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8921" select * from cms_frontusers where identifiant = "a.gaudin16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "8921" select * from cotisations where identifiant = "c.tisserand03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115354 payment_means : VISA transmission_date : 20151114105354 payment_time : 115458 payment_date : 20151114 response_code : 00 payment_certificate : 105c61625d76 authorisation_id : 181082 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 : a.gaudin16 order_id : 8921 customer_email : a.gaudin16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8922" select * from cms_frontusers where identifiant = "a.morancais08" 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 = "8922" select * from cotisations where identifiant = "a.morancais08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115708 payment_means : VISA transmission_date : 20151114105708 payment_time : 115921 payment_date : 20151114 response_code : 00 payment_certificate : 86a1257a0629 authorisation_id : 461161 currency_code : 978 card_number : 4150.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 : a.morancais08 order_id : 8922 customer_email : a.morancais08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8923" select * from cms_frontusers where identifiant = "m.aubert02" 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 = "8923" select * from cotisations where identifiant = "m.aubert02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132631 payment_means : MASTERCARD transmission_date : 20151114122631 payment_time : 132803 payment_date : 20151114 response_code : 00 payment_certificate : 653c69b194ca authorisation_id : 162551 currency_code : 978 card_number : 5131.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 : m.aubert02 order_id : 8923 customer_email : m.aubert02@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 = "8925" select * from cms_frontusers where identifiant = "k.ranchy27" 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 = "8925" select * from cotisations where identifiant = "k.ranchy27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 135044 payment_means : MASTERCARD transmission_date : 20151114125044 payment_time : 141320 payment_date : 20151114 response_code : 00 payment_certificate : b78069bc4b65 authorisation_id : 222431 currency_code : 978 card_number : 5132.98 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : k.ranchy27 order_id : 8925 customer_email : k.ranchy27@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 = "8926" select * from cms_frontusers where identifiant = "a.poujaud26" 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 = "8926" select * from cotisations where identifiant = "a.sevestre21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141334 payment_means : MASTERCARD transmission_date : 20151114131334 payment_time : 141732 payment_date : 20151114 response_code : 00 payment_certificate : 46ea3f85561b authorisation_id : 283951 currency_code : 978 card_number : 5131.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 : a.poujaud26 order_id : 8926 customer_email : a.poujaud26@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 = "8927" select * from cms_frontusers where identifiant = "a.chollet09" 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 = "8927" select * from cotisations where identifiant = "m.renaudin10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142226 payment_means : MASTERCARD transmission_date : 20151114132226 payment_time : 142341 payment_date : 20151114 response_code : 00 payment_certificate : 0d0c6479e345 authorisation_id : 002380 currency_code : 978 card_number : 5432.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 : a.chollet09 order_id : 8927 customer_email : a.chollet09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8928" select * from cms_frontusers where identifiant = "g.martin25" 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 = "8928" select * from cotisations where identifiant = "g.martin25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 143520 payment_means : VISA transmission_date : 20151114133520 payment_time : 143733 payment_date : 20151114 response_code : 00 payment_certificate : 43f57f6a7055 authorisation_id : 586346 currency_code : 978 card_number : 4975.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.martin25 order_id : 8928 customer_email : g.martin25@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 = "8924" select * from cms_frontusers where identifiant = "q.colin03" 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 = "8924" select * from cotisations where identifiant = "q.colin03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132736 payment_means : VISA transmission_date : 20151114122736 payment_time : 150258 payment_date : 20151114 response_code : 00 payment_certificate : 442b1f3a8811 authorisation_id : 803031 currency_code : 978 card_number : 4974.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 : q.colin03 order_id : 8924 customer_email : q.colin03@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 = "8929" select * from cms_frontusers where identifiant = "d.deparday05" 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 = "8929" select * from cotisations where identifiant = "d.deparday05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 150716 payment_means : VISA transmission_date : 20151114140716 payment_time : 150907 payment_date : 20151114 response_code : 00 payment_certificate : ee88d7e52493 authorisation_id : 996519 currency_code : 978 card_number : 4975.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 : d.deparday05 order_id : 8929 customer_email : d.deparday05@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8931" select * from cms_frontusers where identifiant = "f.gomez27" 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 = "8931" select * from cotisations where identifiant = "f.gomez27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153008 payment_means : MASTERCARD transmission_date : 20151114143008 payment_time : 153404 payment_date : 20151114 response_code : 00 payment_certificate : 2553ebb87e63 authorisation_id : 526492 currency_code : 978 card_number : 5132.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.gomez27 order_id : 8931 customer_email : f.gomez27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 153852 payment_means : VISA transmission_date : 20151114143852 payment_time : 154044 payment_date : 20151114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.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 : a.laurain03 order_id : 8932 customer_email : a.laurain03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8933" select * from cms_frontusers where identifiant = "a.laurain03" 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 = "8933" select * from cotisations where identifiant = "t.panighi18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154230 payment_means : VISA transmission_date : 20151114144230 payment_time : 154448 payment_date : 20151114 response_code : 00 payment_certificate : 9774f87eef2f authorisation_id : 622165 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 : a.laurain03 order_id : 8933 customer_email : a.laurain03@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 = "8934" select * from cms_frontusers where identifiant = "a.laurain03" 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 = "8934" select * from cotisations where identifiant = "t.pochet24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154554 payment_means : VISA transmission_date : 20151114144554 payment_time : 154809 payment_date : 20151114 response_code : 00 payment_certificate : c50c993d1dda authorisation_id : 766523 currency_code : 978 card_number : 4978.81 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.laurain03 order_id : 8934 customer_email : a.laurain03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 155115 payment_means : VISA transmission_date : 20151114145115 payment_time : 155240 payment_date : 20151114 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.12 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 : a.vivier16 order_id : 8935 customer_email : a.vivier16@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 : 155539 payment_means : VISA transmission_date : 20151114145539 payment_time : 155701 payment_date : 20151114 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.12 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 : a.vivier16 order_id : 8935 customer_email : a.vivier16@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 = "8936" select * from cms_frontusers where identifiant = "p.sommant26" 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 = "8936" select * from cotisations where identifiant = "p.sommant26" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161429 payment_means : VISA transmission_date : 20151114151429 payment_time : 161903 payment_date : 20151114 response_code : 00 payment_certificate : 90c2b60fe97e authorisation_id : 296233 currency_code : 978 card_number : 4150.95 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.sommant26 order_id : 8936 customer_email : p.sommant26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8937" select * from cms_frontusers where identifiant = "d.rousseau31" 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 = "8937" select * from cotisations where identifiant = "n.lhotellier25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172117 payment_means : VISA transmission_date : 20151114162117 payment_time : 172209 payment_date : 20151114 response_code : 00 payment_certificate : cdb78d98c4b3 authorisation_id : 525349 currency_code : 978 card_number : 4201.48 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.rousseau31 order_id : 8937 customer_email : d.rousseau31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8938" select * from cms_frontusers where identifiant = "j.guillaume24" 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 = "8938" select * from cotisations where identifiant = "b.gueville31" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 181417 payment_means : MASTERCARD transmission_date : 20151114171417 payment_time : 181743 payment_date : 20151114 response_code : 00 payment_certificate : f978d78c2647 authorisation_id : 655622 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 : j.guillaume24 order_id : 8938 customer_email : j.guillaume24@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 = "8939" select * from cms_frontusers where identifiant = "g.carre28" 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 = "8939" select * from cotisations where identifiant = "g.carre28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182446 payment_means : MASTERCARD transmission_date : 20151114172446 payment_time : 182850 payment_date : 20151114 response_code : 00 payment_certificate : 252475ba15db authorisation_id : 912244 currency_code : 978 card_number : 5131.35 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.carre28 order_id : 8939 customer_email : g.carre28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182625 payment_means : MASTERCARD transmission_date : 20151114172625 payment_time : 183418 payment_date : 20151114 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.josselin20 order_id : 8940 customer_email : j.josselin20@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 : 201511 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8940" select * from cms_frontusers where identifiant = "j.josselin20" 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 = "8940" select * from cotisations where identifiant = "j.josselin20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184215 payment_means : MASTERCARD transmission_date : 20151114174215 payment_time : 184502 payment_date : 20151114 response_code : 00 payment_certificate : af85cabe87e2 authorisation_id : 717591 currency_code : 978 card_number : 5132.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.josselin20 order_id : 8940 customer_email : j.josselin20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8941" select * from cms_frontusers where identifiant = "y.loison13" 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 = "8941" select * from cotisations where identifiant = "y.loison13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190454 payment_means : VISA transmission_date : 20151114180454 payment_time : 190814 payment_date : 20151114 response_code : 00 payment_certificate : f0c1ee36997b authorisation_id : 511950 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 : y.loison13 order_id : 8941 customer_email : y.loison13@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 = "8943" select * from cms_frontusers where identifiant = "g.lesaffre10" 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 = "8943" select * from cotisations where identifiant = "g.lesaffre10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 193156 payment_means : MASTERCARD transmission_date : 20151114183156 payment_time : 193407 payment_date : 20151114 response_code : 00 payment_certificate : 018fe2efce85 authorisation_id : 475697 currency_code : 978 card_number : 5341.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 : g.lesaffre10 order_id : 8943 customer_email : g.lesaffre10@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 = "8944" select * from cms_frontusers where identifiant = "m.lefranc01" 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 = "8944" select * from cotisations where identifiant = "m.lefranc01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194008 payment_means : MASTERCARD transmission_date : 20151114184008 payment_time : 194447 payment_date : 20151114 response_code : 00 payment_certificate : 5cca23ee484e authorisation_id : 464593 currency_code : 978 card_number : 5131.95 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.lefranc01 order_id : 8944 customer_email : m.lefranc01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8945" select * from cms_frontusers where identifiant = "d.depuydt02" 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 = "8945" select * from cotisations where identifiant = "d.depuydt02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203219 payment_means : VISA transmission_date : 20151114193219 payment_time : 203257 payment_date : 20151114 response_code : 00 payment_certificate : 551deb55c3f3 authorisation_id : 126367 currency_code : 978 card_number : 4940.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.depuydt02 order_id : 8945 customer_email : d.depuydt02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "8946" select * from cms_frontusers where identifiant = "c.regad23" 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 = "8946" select * from cotisations where identifiant = "c.regad23" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213547 payment_means : VISA transmission_date : 20151114203547 payment_time : 213925 payment_date : 20151114 response_code : 00 payment_certificate : 5b7654684d60 authorisation_id : 230529 currency_code : 978 card_number : 4978.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 : c.regad23 order_id : 8946 customer_email : c.regad23@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 : -------------------------------------------