select * from cotisations_commande where id = "3505" select * from cms_frontusers where identifiant = "s.boisard30" 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 = "3505" select * from cotisations where identifiant = "s.boisard30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 071047 payment_means : MASTERCARD transmission_date : 20141201061047 payment_time : 071435 payment_date : 20141201 response_code : 00 payment_certificate : c73f948c884c authorisation_id : 841184 currency_code : 978 card_number : 5131.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.boisard30 order_id : 3505 customer_email : s.boisard30@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 = "3506" select * from cms_frontusers where identifiant = "d.hamon20" 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 = "3506" select * from cotisations where identifiant = "d.hamon20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103907 payment_means : MASTERCARD transmission_date : 20141201093907 payment_time : 104402 payment_date : 20141201 response_code : 00 payment_certificate : 317665123349 authorisation_id : 104304 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 : d.hamon20 order_id : 3506 customer_email : d.hamon20@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 : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3508" select * from cms_frontusers where identifiant = "a.lovichi29" 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 = "3508" select * from cotisations where identifiant = "p.dasilva29" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 111923 payment_means : VISA transmission_date : 20141201101923 payment_time : 112244 payment_date : 20141201 response_code : 00 payment_certificate : 852ddd84bba0 authorisation_id : 220546 currency_code : 978 card_number : 4976.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 : a.lovichi29 order_id : 3508 customer_email : a.lovichi29@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 = "3517" select * from cms_frontusers where identifiant = "y.wilhelm07" 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 = "3517" select * from cotisations where identifiant = "y.wilhelm07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151429 payment_means : VISA transmission_date : 20141201141429 payment_time : 151829 payment_date : 20141201 response_code : 00 payment_certificate : 16c787323e50 authorisation_id : 656156 currency_code : 978 card_number : 4974.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.wilhelm07 order_id : 3517 customer_email : y.wilhelm07@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 = "3518" select * from cms_frontusers where identifiant = "m.cochard10" 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 = "3518" select * from cotisations where identifiant = "m.cochard10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154226 payment_means : VISA transmission_date : 20141201144226 payment_time : 154414 payment_date : 20141201 response_code : 00 payment_certificate : 6e732ea16416 authorisation_id : 049806 currency_code : 978 card_number : 4950.72 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.cochard10 order_id : 3518 customer_email : m.cochard10@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 : 160401 payment_means : MASTERCARD transmission_date : 20141201150401 payment_time : 150740 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.plevin17 order_id : 3520 customer_email : b.plevin17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3522" select * from cms_frontusers where identifiant = "jp.pages02" 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 = "3522" select * from cotisations where identifiant = "l.yann09" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165453 payment_means : VISA transmission_date : 20141201155453 payment_time : 165630 payment_date : 20141201 response_code : 00 payment_certificate : a4fbf583f3ac authorisation_id : 454469 currency_code : 978 card_number : 4975.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.pages02 order_id : 3522 customer_email : jp.pages02@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 = "3524" select * from cms_frontusers where identifiant = "x.arnold03" 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 = "3524" select * from cotisations where identifiant = "x.arnold03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174335 payment_means : MASTERCARD transmission_date : 20141201164335 payment_time : 174536 payment_date : 20141201 response_code : 00 payment_certificate : 94ecee8f6e76 authorisation_id : 560148 currency_code : 978 card_number : 5132.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.arnold03 order_id : 3524 customer_email : x.arnold03@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 : 201503 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 : 175141 payment_means : MASTERCARD transmission_date : 20141201165141 payment_time : 175434 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.62 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 : e.durand05 order_id : 3525 customer_email : e.durand05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3526" select * from cms_frontusers where identifiant = "r.nogales03" 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 = "3526" select * from cotisations where identifiant = "r.nogales03" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175824 payment_means : VISA transmission_date : 20141201165824 payment_time : 180218 payment_date : 20141201 response_code : 00 payment_certificate : f81d5753cefe authorisation_id : 418206 currency_code : 978 card_number : 4977.21 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.nogales03 order_id : 3526 customer_email : r.nogales03@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3528" select * from cms_frontusers where identifiant = "j.mathieu25" 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 = "3528" select * from cotisations where identifiant = "b.alfonso17" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 180129 payment_means : VISA transmission_date : 20141201170129 payment_time : 180303 payment_date : 20141201 response_code : 00 payment_certificate : fb225373d360 authorisation_id : 869718 currency_code : 978 card_number : 4562.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.mathieu25 order_id : 3528 customer_email : j.mathieu25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182314 payment_means : VISA transmission_date : 20141201172314 payment_time : 182931 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.gallet11 order_id : 3530 customer_email : p.gallet11@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3533" select * from cms_frontusers where identifiant = "c.vareillaud02" 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 = "3533" select * from cotisations where identifiant = "c.vareillaud02" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185627 payment_means : MASTERCARD transmission_date : 20141201175627 payment_time : 185801 payment_date : 20141201 response_code : 00 payment_certificate : ac2e0d8e0ec3 authorisation_id : 544115 currency_code : 978 card_number : 5136.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.vareillaud02 order_id : 3533 customer_email : c.vareillaud02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201512 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 190403 payment_means : VISA transmission_date : 20141201180403 payment_time : 191030 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.gallet11 order_id : 3535 customer_email : p.gallet11@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3537" select * from cms_frontusers where identifiant = "p.mouly26" 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 = "3537" select * from cotisations where identifiant = "p.mouly26" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "p.mouly26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 190748 payment_means : MASTERCARD transmission_date : 20141201180748 payment_time : 191126 payment_date : 20141201 response_code : 00 payment_certificate : 23cd2876dee6 authorisation_id : 524260 currency_code : 978 card_number : 5131.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 : p.mouly26 order_id : 3537 customer_email : p.mouly26@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 = "3540" select * from cms_frontusers where identifiant = "p.mouly26" 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 = "3540" select * from cotisations where identifiant = "c.ferrier08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 191233 payment_means : MASTERCARD transmission_date : 20141201181233 payment_time : 191533 payment_date : 20141201 response_code : 00 payment_certificate : 10f97d2196df authorisation_id : 184669 currency_code : 978 card_number : 5131.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 : p.mouly26 order_id : 3540 customer_email : p.mouly26@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194016 payment_means : MASTERCARD transmission_date : 20141201184016 payment_time : 194136 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.59 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 : g.deshayes06 order_id : 3541 customer_email : g.deshayes06@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 : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3543" select * from cms_frontusers where identifiant = "f.lequellec12" 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 = "3543" select * from cotisations where identifiant = "f.lequellec12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194735 payment_means : VISA transmission_date : 20141201184735 payment_time : 194833 payment_date : 20141201 response_code : 00 payment_certificate : 0ced0fdb8fa3 authorisation_id : 130165 currency_code : 978 card_number : 4975.57 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.lequellec12 order_id : 3543 customer_email : f.lequellec12@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3542" select * from cms_frontusers where identifiant = "y.rainville24" 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 = "3542" select * from cotisations where identifiant = "y.rainville24" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 194422 payment_means : MASTERCARD transmission_date : 20141201184422 payment_time : 194908 payment_date : 20141201 response_code : 00 payment_certificate : 6257e6c46724 authorisation_id : 434974 currency_code : 978 card_number : 5132.04 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.rainville24 order_id : 3542 customer_email : y.rainville24@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3544" select * from cms_frontusers where identifiant = "b.clanche30" 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 = "3544" select * from cotisations where identifiant = "b.clanche30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200127 payment_means : VISA transmission_date : 20141201190127 payment_time : 200734 payment_date : 20141201 response_code : 00 payment_certificate : 796219164c93 authorisation_id : 323153 currency_code : 978 card_number : 4978.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 : b.clanche30 order_id : 3544 customer_email : b.clanche30@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 = "3545" select * from cms_frontusers where identifiant = "a.demond16" 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 = "3545" select * from cotisations where identifiant = "a.demond16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201016 payment_means : VISA transmission_date : 20141201191016 payment_time : 201308 payment_date : 20141201 response_code : 00 payment_certificate : d952747d7f82 authorisation_id : 237525 currency_code : 978 card_number : 4970.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 : a.demond16 order_id : 3545 customer_email : a.demond16@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 = "3553" select * from cms_frontusers where identifiant = "p.avrilla13" 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 = "3553" select * from cotisations where identifiant = "p.avrilla13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202726 payment_means : MASTERCARD transmission_date : 20141201192726 payment_time : 202757 payment_date : 20141201 response_code : 00 payment_certificate : 77a47e33f8c8 authorisation_id : 893003 currency_code : 978 card_number : 5132.56 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.avrilla13 order_id : 3553 customer_email : p.avrilla13@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 : 201412 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 : 201249 payment_means : VISA transmission_date : 20141201191249 payment_time : 202803 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.80 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.mallet18 order_id : 3546 customer_email : a.mallet18@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 : 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 : 202206 payment_means : VISA transmission_date : 20141201192206 payment_time : 202858 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.86 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 : l.delaunay27 order_id : 3550 customer_email : l.delaunay27@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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3550" select * from cms_frontusers where identifiant = "l.delaunay27" 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 = "3550" select * from cotisations where identifiant = "l.delaunay27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202916 payment_means : VISA transmission_date : 20141201192916 payment_time : 203350 payment_date : 20141201 response_code : 00 payment_certificate : 75b0c7a98f06 authorisation_id : 148130 currency_code : 978 card_number : 4970.86 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.delaunay27 order_id : 3550 customer_email : l.delaunay27@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 : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3554" select * from cms_frontusers where identifiant = "m.bardoulat18" 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 = "3554" select * from cotisations where identifiant = "m.bardoulat18" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203247 payment_means : MASTERCARD transmission_date : 20141201193247 payment_time : 203422 payment_date : 20141201 response_code : 00 payment_certificate : f0e872cddd1e authorisation_id : 271130 currency_code : 978 card_number : 5133.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 : m.bardoulat18 order_id : 3554 customer_email : m.bardoulat18@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3555" select * from cms_frontusers where identifiant = "a.deron07" 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 = "3555" select * from cotisations where identifiant = "a.deron07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203620 payment_means : VISA transmission_date : 20141201193620 payment_time : 203917 payment_date : 20141201 response_code : 00 payment_certificate : 867e3eeb363c authorisation_id : 665519 currency_code : 978 card_number : 4970.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.deron07 order_id : 3555 customer_email : a.deron07@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 : 201509 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 : 205037 payment_means : MASTERCARD transmission_date : 20141201195037 payment_time : 205303 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.maurille24 order_id : 3557 customer_email : m.maurille24@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 : 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 : 205219 payment_means : MASTERCARD transmission_date : 20141201195219 payment_time : 205307 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.durand05 order_id : 3560 customer_email : e.durand05@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 : 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 : 205329 payment_means : MASTERCARD transmission_date : 20141201195329 payment_time : 205434 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.durand05 order_id : 3560 customer_email : e.durand05@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 : 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 : 210209 payment_means : MASTERCARD transmission_date : 20141201200209 payment_time : 210253 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.00 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.denoel12 order_id : 3561 customer_email : b.denoel12@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 : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210301 payment_means : MASTERCARD transmission_date : 20141201200301 payment_time : 210430 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.faurevincent16 order_id : 3562 customer_email : n.faurevincent16@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 : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3563" select * from cms_frontusers where identifiant = "mg.cousseau13" 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 = "3563" select * from cotisations where identifiant = "mg.cousseau13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210657 payment_means : MASTERCARD transmission_date : 20141201200657 payment_time : 211450 payment_date : 20141201 response_code : 00 payment_certificate : 59b18c7652f8 authorisation_id : 615351 currency_code : 978 card_number : 5132.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : mg.cousseau13 order_id : 3563 customer_email : mg.cousseau13@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 = "3565" select * from cms_frontusers where identifiant = "q.lintz11" 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 = "3565" select * from cotisations where identifiant = "q.lintz11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 211333 payment_means : VISA transmission_date : 20141201201333 payment_time : 211939 payment_date : 20141201 response_code : 00 payment_certificate : 4aad974eab8b authorisation_id : 211292 currency_code : 978 card_number : 4973.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.lintz11 order_id : 3565 customer_email : q.lintz11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201604 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212435 payment_means : MASTERCARD transmission_date : 20141201202435 payment_time : 212853 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.maurille24 order_id : 3566 customer_email : m.maurille24@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 : 201509 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 : 213017 payment_means : MASTERCARD transmission_date : 20141201203017 payment_time : 213151 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.maurille24 order_id : 3566 customer_email : m.maurille24@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 : 201509 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 : 212846 payment_means : VISA transmission_date : 20141201202846 payment_time : 213603 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.jayle03 order_id : 3567 customer_email : d.jayle03@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 : 201412 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 : 213215 payment_means : MASTERCARD transmission_date : 20141201203215 payment_time : 213655 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.44 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 : m.maurille24 order_id : 3566 customer_email : m.maurille24@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 : 201509 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 : 213532 payment_means : VISA transmission_date : 20141201203532 payment_time : 214126 payment_date : 20141201 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.mallet18 order_id : 3568 customer_email : a.mallet18@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3570" select * from cms_frontusers where identifiant = "t.dasilva26" 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 = "3570" select * from cotisations where identifiant = "t.dasilva26" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214556 payment_means : VISA transmission_date : 20141201204556 payment_time : 214803 payment_date : 20141201 response_code : 00 payment_certificate : d72cc5686f70 authorisation_id : 651231 currency_code : 978 card_number : 4976.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.dasilva26 order_id : 3570 customer_email : t.dasilva26@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 : 201509 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 : 215016 payment_means : MASTERCARD transmission_date : 20141201205016 payment_time : 215136 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.35 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.carre28 order_id : 3571 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_ATTEMPT 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 : 215208 payment_means : MASTERCARD transmission_date : 20141201205208 payment_time : 215313 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.35 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.carre28 order_id : 3571 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_ATTEMPT 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 : 215458 payment_means : MASTERCARD transmission_date : 20141201205458 payment_time : 215824 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.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 : g.carre28 order_id : 3573 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_ATTEMPT statement_reference : card_validity : 201605 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3576" 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 = "3576" select * from cotisations where identifiant = "c.lanaud30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220141 payment_means : VISA transmission_date : 20141201210141 payment_time : 220428 payment_date : 20141201 response_code : 00 payment_certificate : dc5ef3a89ef4 authorisation_id : 648795 currency_code : 978 card_number : 4150.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.deparday05 order_id : 3576 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 : 201503 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3577" select * from cms_frontusers where identifiant = "p.roetsch24" 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 = "3577" select * from cotisations where identifiant = "d1.schmitt23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220619 payment_means : MASTERCARD transmission_date : 20141201210619 payment_time : 220816 payment_date : 20141201 response_code : 00 payment_certificate : 4d6604f691df authorisation_id : 764685 currency_code : 978 card_number : 5132.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.roetsch24 order_id : 3577 customer_email : p.roetsch24@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 : 201501 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 : 221214 payment_means : MASTERCARD transmission_date : 20141201211214 payment_time : 221340 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.archambault11 order_id : 3579 customer_email : jm.archambault11@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221401 payment_means : MASTERCARD transmission_date : 20141201211401 payment_time : 221538 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jm.archambault11 order_id : 3579 customer_email : jm.archambault11@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "3578" select * from cms_frontusers where identifiant = "m.bouvet27" 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 = "3578" select * from cotisations where identifiant = "m.bouvet27" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "m.bouvet27" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221215 payment_means : VISA transmission_date : 20141201211215 payment_time : 221702 payment_date : 20141201 response_code : 00 payment_certificate : a77d12bdcccd authorisation_id : 604644 currency_code : 978 card_number : 4978.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.bouvet27 order_id : 3578 customer_email : m.bouvet27@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 = "3580" select * from cms_frontusers where identifiant = "j.mathieu25" 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 = "3580" select * from cotisations where identifiant = "j.mathieu25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 221923 payment_means : VISA transmission_date : 20141201211923 payment_time : 222139 payment_date : 20141201 response_code : 00 payment_certificate : c5a0949aed50 authorisation_id : 354656 currency_code : 978 card_number : 4562.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 99 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.mathieu25 order_id : 3580 customer_email : j.mathieu25@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 = "3581" select * from cms_frontusers where identifiant = "p.humbert05" 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 = "3581" select * from cotisations where identifiant = "p.humbert05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222010 payment_means : VISA transmission_date : 20141201212010 payment_time : 222201 payment_date : 20141201 response_code : 00 payment_certificate : a973ef1ff1b9 authorisation_id : 430565 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 : p.humbert05 order_id : 3581 customer_email : p.humbert05@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 : 201503 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 : 232741 payment_means : VISA transmission_date : 20141201222741 payment_time : 232848 payment_date : 20141201 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4659.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 54 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.paiva07 order_id : 3582 customer_email : m.paiva07@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 : -------------------------------------------