Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 002129 payment_means : MASTERCARD transmission_date : 20161230232129 payment_time : 002247 payment_date : 20161231 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5133.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.richard23 order_id : 19397 customer_email : v.richard23@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 = "19399" select * from cms_frontusers where identifiant = "n.joubert29" 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 = "19399" select * from cotisations where identifiant = "d.dez09" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "n.joubert29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 011629 payment_means : VISA transmission_date : 20161231001629 payment_time : 012004 payment_date : 20161231 response_code : 00 payment_certificate : fd1f6fdffb97 authorisation_id : 398041 currency_code : 978 card_number : 4978.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : n.joubert29 order_id : 19399 customer_email : n.joubert29@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 = "19402" select * from cms_frontusers where identifiant = "c.creusot07" 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 = "19402" select * from cotisations where identifiant = "c.creusot07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 075401 payment_means : VISA transmission_date : 20161231065401 payment_time : 075459 payment_date : 20161231 response_code : 00 payment_certificate : 326af1def37b authorisation_id : 853842 currency_code : 978 card_number : 4978.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.creusot07 order_id : 19402 customer_email : c.creusot07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075720 payment_means : MASTERCARD transmission_date : 20161231065720 payment_time : 075947 payment_date : 20161231 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 : n.rulland29 order_id : 19403 customer_email : n.rulland29@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 = "19404" select * from cms_frontusers where identifiant = "s1.robert17" 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 = "19404" select * from cotisations where identifiant = "s1.robert17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081649 payment_means : MASTERCARD transmission_date : 20161231071649 payment_time : 081938 payment_date : 20161231 response_code : 00 payment_certificate : 8816fa97cfe0 authorisation_id : 948219 currency_code : 978 card_number : 5131.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 : s1.robert17 order_id : 19404 customer_email : s1.robert17@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 = "19405" select * from cms_frontusers where identifiant = "c.soulard15" 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 = "19405" select * from cotisations where identifiant = "c.soulard15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 091343 payment_means : VISA transmission_date : 20161231081343 payment_time : 091545 payment_date : 20161231 response_code : 00 payment_certificate : fcfebbffc15c authorisation_id : 463627 currency_code : 978 card_number : 4533.23 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.soulard15 order_id : 19405 customer_email : c.soulard15@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091658 payment_means : MASTERCARD transmission_date : 20161231081658 payment_time : 091756 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.soulard15 order_id : 19407 customer_email : c.soulard15@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 = "19406" select * from cms_frontusers where identifiant = "b.gelle28" 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 = "19406" select * from cotisations where identifiant = "b.gelle28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091450 payment_means : MASTERCARD transmission_date : 20161231081450 payment_time : 091844 payment_date : 20161231 response_code : 00 payment_certificate : af9b9b9bad14 authorisation_id : 354419 currency_code : 978 card_number : 5137.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 : b.gelle28 order_id : 19406 customer_email : b.gelle28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091806 payment_means : MASTERCARD transmission_date : 20161231081806 payment_time : 091917 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.soulard15 order_id : 19407 customer_email : c.soulard15@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 = "19407" select * from cms_frontusers where identifiant = "c.soulard15" 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 = "19407" select * from cotisations where identifiant = "s.soulard27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091924 payment_means : MASTERCARD transmission_date : 20161231081924 payment_time : 092115 payment_date : 20161231 response_code : 00 payment_certificate : 80b8b8ea8f3c authorisation_id : 258608 currency_code : 978 card_number : 5137.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.soulard15 order_id : 19407 customer_email : c.soulard15@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 = "19409" select * from cms_frontusers where identifiant = "js.otto08" 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 = "19409" select * from cotisations where identifiant = "js.otto08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 100648 payment_means : VISA transmission_date : 20161231090648 payment_time : 100829 payment_date : 20161231 response_code : 00 payment_certificate : f5cb2fde7b1a authorisation_id : 544229 currency_code : 978 card_number : 4970.64 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : js.otto08 order_id : 19409 customer_email : js.otto08@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 = "19411" select * from cms_frontusers where identifiant = "s.debortoli05" 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 = "19411" select * from cotisations where identifiant = "s.debortoli05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101838 payment_means : VISA transmission_date : 20161231091838 payment_time : 101958 payment_date : 20161231 response_code : 00 payment_certificate : bc47426d8163 authorisation_id : 356354 currency_code : 978 card_number : 4975.51 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.debortoli05 order_id : 19411 customer_email : s.debortoli05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19413" select * from cms_frontusers where identifiant = "t.lievin07" 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 = "19413" select * from cotisations where identifiant = "t.lievin07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102746 payment_means : MASTERCARD transmission_date : 20161231092746 payment_time : 103114 payment_date : 20161231 response_code : 00 payment_certificate : 6aa2ea6483fc authorisation_id : 955302 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 : t.lievin07 order_id : 19413 customer_email : t.lievin07@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 : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19415" select * from cms_frontusers where identifiant = "d.reljac19" 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 = "19415" select * from cotisations where identifiant = "d.reljac19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104511 payment_means : VISA transmission_date : 20161231094511 payment_time : 104646 payment_date : 20161231 response_code : 00 payment_certificate : 547c8f9c0fff authorisation_id : 563108 currency_code : 978 card_number : 4978.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.reljac19 order_id : 19415 customer_email : d.reljac19@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 : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19418" select * from cms_frontusers where identifiant = "pe.bon11" 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 = "19418" select * from cotisations where identifiant = "pe.bon11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105847 payment_means : MASTERCARD transmission_date : 20161231095847 payment_time : 110012 payment_date : 20161231 response_code : 00 payment_certificate : 76f95bcad8bb authorisation_id : 370259 currency_code : 978 card_number : 5131.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : pe.bon11 order_id : 19418 customer_email : pe.bon11@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 = "19417" select * from cms_frontusers where identifiant = "j.maccard31" 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 = "19417" select * from cotisations where identifiant = "j.maccard31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105503 payment_means : MASTERCARD transmission_date : 20161231095503 payment_time : 110048 payment_date : 20161231 response_code : 00 payment_certificate : c694d146b63d authorisation_id : 565992 currency_code : 978 card_number : 5137.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 : j.maccard31 order_id : 19417 customer_email : j.maccard31@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 : 105326 payment_means : VISA transmission_date : 20161231095326 payment_time : 110233 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d1.sourice21 order_id : 19416 customer_email : d1.sourice21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19416" select * from cms_frontusers where identifiant = "d1.sourice21" 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 = "19416" select * from cotisations where identifiant = "d1.sourice21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110321 payment_means : VISA transmission_date : 20161231100321 payment_time : 110638 payment_date : 20161231 response_code : 00 payment_certificate : 2467d379e320 authorisation_id : 781513 currency_code : 978 card_number : 4978.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d1.sourice21 order_id : 19416 customer_email : d1.sourice21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111312 payment_means : MASTERCARD transmission_date : 20161231101312 payment_time : 111529 payment_date : 20161231 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.mary14 order_id : 19420 customer_email : y.mary14@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 : 201807 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19421" select * from cms_frontusers where identifiant = "p.berrue01" 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 = "19421" select * from cotisations where identifiant = "p.berrue01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111858 payment_means : VISA transmission_date : 20161231101858 payment_time : 112445 payment_date : 20161231 response_code : 00 payment_certificate : ca289d1c94c4 authorisation_id : 316636 currency_code : 978 card_number : 4975.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.berrue01 order_id : 19421 customer_email : p.berrue01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19422" select * from cms_frontusers where identifiant = "d.chassevent06" 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 = "19422" select * from cotisations where identifiant = "d.chassevent06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113149 payment_means : MASTERCARD transmission_date : 20161231103149 payment_time : 113325 payment_date : 20161231 response_code : 00 payment_certificate : 36aaab15eb1f authorisation_id : 152502 currency_code : 978 card_number : 5131.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 : d.chassevent06 order_id : 19422 customer_email : d.chassevent06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113520 payment_means : VISA transmission_date : 20161231103520 payment_time : 113636 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.senouque01 order_id : 19423 customer_email : t.senouque01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19424" select * from cms_frontusers where identifiant = "d.ejarque08" 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 = "19424" select * from cotisations where identifiant = "d.ejarque08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113659 payment_means : VISA transmission_date : 20161231103659 payment_time : 113824 payment_date : 20161231 response_code : 00 payment_certificate : 1d7e8e7651d9 authorisation_id : 296851 currency_code : 978 card_number : 4975.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 : d.ejarque08 order_id : 19424 customer_email : d.ejarque08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19423" select * from cms_frontusers where identifiant = "t.senouque01" 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 = "19423" select * from cotisations where identifiant = "t.senouque01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113643 payment_means : VISA transmission_date : 20161231103643 payment_time : 114144 payment_date : 20161231 response_code : 00 payment_certificate : 400763b7e8a2 authorisation_id : 232568 currency_code : 978 card_number : 4975.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.senouque01 order_id : 19423 customer_email : t.senouque01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19425" select * from cms_frontusers where identifiant = "p.berrue01" 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 = "19425" select * from cotisations where identifiant = "c.labouesse02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 113727 payment_means : VISA transmission_date : 20161231103727 payment_time : 114621 payment_date : 20161231 response_code : 00 payment_certificate : 609289b6ed20 authorisation_id : 571411 currency_code : 978 card_number : 4975.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.berrue01 order_id : 19425 customer_email : p.berrue01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19426" select * from cms_frontusers where identifiant = "j.pitiot20" 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 = "19426" select * from cotisations where identifiant = "j.pitiot20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114550 payment_means : VISA transmission_date : 20161231104550 payment_time : 114729 payment_date : 20161231 response_code : 00 payment_certificate : bb2705e0fdb6 authorisation_id : 120538 currency_code : 978 card_number : 4973.24 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.pitiot20 order_id : 19426 customer_email : j.pitiot20@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 : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19427" select * from cms_frontusers where identifiant = "c.harnois16" 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 = "19427" select * from cotisations where identifiant = "c.harnois16" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "19428" select * from cms_frontusers where identifiant = "d.lorton16" code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114625 payment_means : VISA transmission_date : 20161231104625 payment_time : 114849 payment_date : 20161231 response_code : 00 payment_certificate : 2fd66c51d5f7 authorisation_id : 299424 currency_code : 978 card_number : 4970.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 : c.harnois16 order_id : 19427 customer_email : c.harnois16@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 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 = "19428" select * from cotisations where identifiant = "d.lorton16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114824 payment_means : MASTERCARD transmission_date : 20161231104824 payment_time : 115119 payment_date : 20161231 response_code : 00 payment_certificate : 4c80ed3b2cf1 authorisation_id : 762455 currency_code : 978 card_number : 5131.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 : d.lorton16 order_id : 19428 customer_email : d.lorton16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19429" select * from cms_frontusers where identifiant = "q.alexandre09" 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 = "19429" select * from cotisations where identifiant = "q.alexandre09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115954 payment_means : VISA transmission_date : 20161231105954 payment_time : 120304 payment_date : 20161231 response_code : 00 payment_certificate : 6d5a71b2832d authorisation_id : 186585 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 : q.alexandre09 order_id : 19429 customer_email : q.alexandre09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19430" select * from cms_frontusers where identifiant = "h.dacostalopes07" 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 = "19430" select * from cotisations where identifiant = "h.dacostalopes07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 120545 payment_means : MASTERCARD transmission_date : 20161231110545 payment_time : 120725 payment_date : 20161231 response_code : 00 payment_certificate : 9d0af8107c5e authorisation_id : 223310 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 : h.dacostalopes07 order_id : 19430 customer_email : h.dacostalopes07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19431" select * from cms_frontusers where identifiant = "s.poilane21" 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 = "19431" select * from cotisations where identifiant = "s.poilane21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120608 payment_means : MASTERCARD transmission_date : 20161231110608 payment_time : 120756 payment_date : 20161231 response_code : 00 payment_certificate : 04b88e267d94 authorisation_id : 155273 currency_code : 978 card_number : 5131.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.poilane21 order_id : 19431 customer_email : s.poilane21@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 = "19432" select * from cms_frontusers where identifiant = "a.quaesaet01" 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 = "19432" select * from cotisations where identifiant = "a.quaesaet01" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "a.quaesaet01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120651 payment_means : MASTERCARD transmission_date : 20161231110651 payment_time : 120824 payment_date : 20161231 response_code : 00 payment_certificate : 29a0e2a5db60 authorisation_id : 699866 currency_code : 978 card_number : 5134.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 : a.quaesaet01 order_id : 19432 customer_email : a.quaesaet01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19433" select * from cms_frontusers where identifiant = "r.quichaud31" 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 = "19433" select * from cotisations where identifiant = "r.quichaud31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 120751 payment_means : VISA transmission_date : 20161231110751 payment_time : 120918 payment_date : 20161231 response_code : 00 payment_certificate : 7928527ceaa9 authorisation_id : 129004 currency_code : 978 card_number : 4975.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.quichaud31 order_id : 19433 customer_email : r.quichaud31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19434" select * from cms_frontusers where identifiant = "x.imhof16" 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 = "19434" select * from cotisations where identifiant = "x.imhof16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122731 payment_means : VISA transmission_date : 20161231112731 payment_time : 123004 payment_date : 20161231 response_code : 00 payment_certificate : 63e1db64738e authorisation_id : 948345 currency_code : 978 card_number : 4975.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 : x.imhof16 order_id : 19434 customer_email : x.imhof16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19435" select * from cms_frontusers where identifiant = "f.collin01" 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 = "19435" select * from cotisations where identifiant = "f.collin01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124147 payment_means : MASTERCARD transmission_date : 20161231114147 payment_time : 124307 payment_date : 20161231 response_code : 00 payment_certificate : f9fa9f73898c authorisation_id : 264332 currency_code : 978 card_number : 5131.70 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.collin01 order_id : 19435 customer_email : f.collin01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19436" select * from cms_frontusers where identifiant = "f.collin01" 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 = "19436" select * from cotisations where identifiant = "f.collin01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 124422 payment_means : MASTERCARD transmission_date : 20161231114422 payment_time : 124544 payment_date : 20161231 response_code : 00 payment_certificate : 1e77ed4fc9de authorisation_id : 534542 currency_code : 978 card_number : 5131.70 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.collin01 order_id : 19436 customer_email : f.collin01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19437" select * from cms_frontusers where identifiant = "c.ledevendec03" 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 = "19437" select * from cotisations where identifiant = "c.ledevendec03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124644 payment_means : MASTERCARD transmission_date : 20161231114644 payment_time : 124928 payment_date : 20161231 response_code : 00 payment_certificate : e16e91e9b617 authorisation_id : 287624 currency_code : 978 card_number : 5137.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 : c.ledevendec03 order_id : 19437 customer_email : c.ledevendec03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19438" select * from cms_frontusers where identifiant = "a.dollet20" 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 = "19438" select * from cotisations where identifiant = "a.dollet20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130058 payment_means : VISA transmission_date : 20161231120058 payment_time : 130310 payment_date : 20161231 response_code : 00 payment_certificate : da63b5e795f6 authorisation_id : 652736 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 : a.dollet20 order_id : 19438 customer_email : a.dollet20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19439" select * from cms_frontusers where identifiant = "g.jansen13" 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 = "19439" select * from cotisations where identifiant = "g.jansen13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130139 payment_means : VISA transmission_date : 20161231120139 payment_time : 130354 payment_date : 20161231 response_code : 00 payment_certificate : 5adb88368485 authorisation_id : 547665 currency_code : 978 card_number : 4972.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.jansen13 order_id : 19439 customer_email : g.jansen13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19440" select * from cms_frontusers where identifiant = "jp.bonnet01" 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 = "19440" select * from cotisations where identifiant = "jp.bonnet01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130944 payment_means : VISA transmission_date : 20161231120944 payment_time : 131148 payment_date : 20161231 response_code : 00 payment_certificate : 2bca8d42ab72 authorisation_id : 922435 currency_code : 978 card_number : 4975.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 : jp.bonnet01 order_id : 19440 customer_email : jp.bonnet01@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 = "19441" select * from cms_frontusers where identifiant = "f.lenestour21" 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 = "19441" select * from cotisations where identifiant = "f.lenestour21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131940 payment_means : MASTERCARD transmission_date : 20161231121940 payment_time : 132207 payment_date : 20161231 response_code : 00 payment_certificate : 6148c8f32c22 authorisation_id : 530406 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 : f.lenestour21 order_id : 19441 customer_email : f.lenestour21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19444" select * from cms_frontusers where identifiant = "jl.tribouiller17" 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 = "19444" select * from cotisations where identifiant = "jl.tribouiller17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134553 payment_means : MASTERCARD transmission_date : 20161231124553 payment_time : 134732 payment_date : 20161231 response_code : 00 payment_certificate : 4501f75550ba authorisation_id : 644054 currency_code : 978 card_number : 5137.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.tribouiller17 order_id : 19444 customer_email : jl.tribouiller17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19447" select * from cms_frontusers where identifiant = "j.schmidt03" 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 = "19447" select * from cotisations where identifiant = "j.schmidt03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134748 payment_means : VISA transmission_date : 20161231124748 payment_time : 134958 payment_date : 20161231 response_code : 00 payment_certificate : 063281417721 authorisation_id : 242227 currency_code : 978 card_number : 4978.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.schmidt03 order_id : 19447 customer_email : j.schmidt03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 134434 payment_means : VISA transmission_date : 20161231124434 payment_time : 135335 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.78 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.bonnefond06 order_id : 19443 customer_email : r.bonnefond06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19449" select * from cms_frontusers where identifiant = "e.jeandet06" 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 = "19449" select * from cotisations where identifiant = "e.jeandet06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141003 payment_means : VISA transmission_date : 20161231131003 payment_time : 141312 payment_date : 20161231 response_code : 00 payment_certificate : 080426db6b4a authorisation_id : 537754 currency_code : 978 card_number : 4974.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 : e.jeandet06 order_id : 19449 customer_email : e.jeandet06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19450" select * from cms_frontusers where identifiant = "c.moutiez14" 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 = "19450" select * from cotisations where identifiant = "c.moutiez14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141442 payment_means : VISA transmission_date : 20161231131442 payment_time : 141723 payment_date : 20161231 response_code : 00 payment_certificate : b15fdc53de25 authorisation_id : 778890 currency_code : 978 card_number : 4978.63 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.moutiez14 order_id : 19450 customer_email : c.moutiez14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19451" select * from cms_frontusers where identifiant = "a.bret20" 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 = "19451" select * from cotisations where identifiant = "a.bret20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141646 payment_means : MASTERCARD transmission_date : 20161231131646 payment_time : 141828 payment_date : 20161231 response_code : 00 payment_certificate : 1421de3ddfba authorisation_id : 045302 currency_code : 978 card_number : 5132.23 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.bret20 order_id : 19451 customer_email : a.bret20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19452" select * from cms_frontusers where identifiant = "jc.giot05" 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 = "19452" select * from cotisations where identifiant = "jc.giot05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 142519 payment_means : VISA transmission_date : 20161231132519 payment_time : 142736 payment_date : 20161231 response_code : 00 payment_certificate : bcbd98fbb07e authorisation_id : 129200 currency_code : 978 card_number : 4975.55 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.giot05 order_id : 19452 customer_email : jc.giot05@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 = "19453" select * from cms_frontusers where identifiant = "c.aubin22" 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 = "19453" select * from cotisations where identifiant = "c.aubin22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 144324 payment_means : VISA transmission_date : 20161231134324 payment_time : 144510 payment_date : 20161231 response_code : 00 payment_certificate : 210052f43c21 authorisation_id : 552502 currency_code : 978 card_number : 4978.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 : c.aubin22 order_id : 19453 customer_email : c.aubin22@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 = "19454" select * from cms_frontusers where identifiant = "l.jaud23" 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 = "19454" select * from cotisations where identifiant = "l.jaud23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145830 payment_means : MASTERCARD transmission_date : 20161231135830 payment_time : 150437 payment_date : 20161231 response_code : 00 payment_certificate : b8ccdb867c08 authorisation_id : 183237 currency_code : 978 card_number : 5132.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 : l.jaud23 order_id : 19454 customer_email : l.jaud23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19455" select * from cms_frontusers where identifiant = "d.girardet28" 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 = "19455" select * from cotisations where identifiant = "d.girardet28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151010 payment_means : VISA transmission_date : 20161231141010 payment_time : 151634 payment_date : 20161231 response_code : 00 payment_certificate : 635f29a66059 authorisation_id : 096257 currency_code : 978 card_number : 4975.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.girardet28 order_id : 19455 customer_email : d.girardet28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19456" select * from cms_frontusers where identifiant = "r.lestruhaut06" 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 = "19456" select * from cotisations where identifiant = "r.lestruhaut06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 151158 payment_means : VISA transmission_date : 20161231141158 payment_time : 152546 payment_date : 20161231 response_code : 00 payment_certificate : e98db17b6fc6 authorisation_id : 547512 currency_code : 978 card_number : 4150.96 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.lestruhaut06 order_id : 19456 customer_email : r.lestruhaut06@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 = "19457" select * from cms_frontusers where identifiant = "v.courtial21" 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 = "19457" select * from cotisations where identifiant = "v.courtial21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152721 payment_means : VISA transmission_date : 20161231142721 payment_time : 152852 payment_date : 20161231 response_code : 00 payment_certificate : 7052033dfb24 authorisation_id : 705909 currency_code : 978 card_number : 4976.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 : v.courtial21 order_id : 19457 customer_email : v.courtial21@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 = "19458" select * from cms_frontusers where identifiant = "l.fournier13" 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 = "19458" select * from cotisations where identifiant = "l.fournier13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152812 payment_means : MASTERCARD transmission_date : 20161231142812 payment_time : 152950 payment_date : 20161231 response_code : 00 payment_certificate : b55d985102a7 authorisation_id : 491815 currency_code : 978 card_number : 5137.60 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.fournier13 order_id : 19458 customer_email : l.fournier13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152929 payment_means : VISA transmission_date : 20161231142929 payment_time : 153904 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.andreu10 order_id : 19459 customer_email : r.andreu10@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 = "19460" select * from cms_frontusers where identifiant = "p.gernigon26" 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 = "19460" select * from cotisations where identifiant = "p.gernigon26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153823 payment_means : VISA transmission_date : 20161231143823 payment_time : 154043 payment_date : 20161231 response_code : 00 payment_certificate : b119faae834a authorisation_id : 441543 currency_code : 978 card_number : 4975.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.gernigon26 order_id : 19460 customer_email : p.gernigon26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19459" select * from cms_frontusers where identifiant = "r.andreu10" 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 = "19459" select * from cotisations where identifiant = "r.andreu10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153913 payment_means : VISA transmission_date : 20161231143913 payment_time : 154133 payment_date : 20161231 response_code : 00 payment_certificate : 4e83fbf50704 authorisation_id : 356468 currency_code : 978 card_number : 4973.37 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.andreu10 order_id : 19459 customer_email : r.andreu10@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 = "19461" select * from cms_frontusers where identifiant = "m.peyreigne01" 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 = "19461" select * from cotisations where identifiant = "m.peyreigne01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 154636 payment_means : MASTERCARD transmission_date : 20161231144636 payment_time : 154859 payment_date : 20161231 response_code : 00 payment_certificate : ceacb5ad3587 authorisation_id : 112481 currency_code : 978 card_number : 5137.75 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.peyreigne01 order_id : 19461 customer_email : m.peyreigne01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19462" select * from cms_frontusers where identifiant = "m.dequi16" 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 = "19462" select * from cotisations where identifiant = "m.dequi16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155102 payment_means : VISA transmission_date : 20161231145102 payment_time : 155432 payment_date : 20161231 response_code : 00 payment_certificate : fd5e42e101db authorisation_id : 255903 currency_code : 978 card_number : 4975.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 : m.dequi16 order_id : 19462 customer_email : m.dequi16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155444 payment_means : VISA transmission_date : 20161231145444 payment_time : 160451 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4972.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.houel12 order_id : 19463 customer_email : c.houel12@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19464" select * from cms_frontusers where identifiant = "s.jahno13" 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 = "19464" select * from cotisations where identifiant = "s.jahno13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 160635 payment_means : MASTERCARD transmission_date : 20161231150635 payment_time : 161032 payment_date : 20161231 response_code : 00 payment_certificate : ff7952ab7a82 authorisation_id : 524242 currency_code : 978 card_number : 5131.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 : s.jahno13 order_id : 19464 customer_email : s.jahno13@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 = "19463" select * from cms_frontusers where identifiant = "c.houel12" 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 = "19463" select * from cotisations where identifiant = "c.houel12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161510 payment_means : VISA transmission_date : 20161231151510 payment_time : 161841 payment_date : 20161231 response_code : 00 payment_certificate : c0b0b22615f0 authorisation_id : 660395 currency_code : 978 card_number : 4978.63 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.houel12 order_id : 19463 customer_email : c.houel12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19466" select * from cms_frontusers where identifiant = "i.collet07" 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 = "19466" select * from cotisations where identifiant = "i.collet07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164146 payment_means : VISA transmission_date : 20161231154146 payment_time : 164306 payment_date : 20161231 response_code : 00 payment_certificate : 47d471e0605f authorisation_id : 831492 currency_code : 978 card_number : 4970.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 : i.collet07 order_id : 19466 customer_email : i.collet07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19465" select * from cms_frontusers where identifiant = "a.vazquez01" 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 = "19465" select * from cotisations where identifiant = "a.vazquez01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 162802 payment_means : MASTERCARD transmission_date : 20161231152802 payment_time : 164946 payment_date : 20161231 response_code : 00 payment_certificate : f5bbd6abd963 authorisation_id : 465125 currency_code : 978 card_number : 5132.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.vazquez01 order_id : 19465 customer_email : a.vazquez01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19468" select * from cms_frontusers where identifiant = "jc.canac03" 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 = "19468" select * from cotisations where identifiant = "jc.canac03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165839 payment_means : VISA transmission_date : 20161231155839 payment_time : 170008 payment_date : 20161231 response_code : 00 payment_certificate : 2111d4dac6e3 authorisation_id : 642862 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 : jc.canac03 order_id : 19468 customer_email : jc.canac03@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 : 4000 transaction_id : 165850 payment_means : MASTERCARD transmission_date : 20161231155850 payment_time : 170059 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5656.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 : c.logiez08 order_id : 19469 customer_email : c.logiez08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19470" select * from cms_frontusers where identifiant = "n.verneuil17" 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 = "19470" select * from cotisations where identifiant = "n.verneuil17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 170230 payment_means : VISA transmission_date : 20161231160230 payment_time : 170352 payment_date : 20161231 response_code : 00 payment_certificate : f5e9fe9c3ed9 authorisation_id : 382836 currency_code : 978 card_number : 4561.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 : n.verneuil17 order_id : 19470 customer_email : n.verneuil17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19472" select * from cms_frontusers where identifiant = "y.pantaleon13" 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 = "19472" select * from cotisations where identifiant = "r.fumard15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173122 payment_means : MASTERCARD transmission_date : 20161231163122 payment_time : 173320 payment_date : 20161231 response_code : 00 payment_certificate : f69a665c82d5 authorisation_id : 846135 currency_code : 978 card_number : 5131.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.pantaleon13 order_id : 19472 customer_email : y.pantaleon13@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 = "19473" select * from cms_frontusers where identifiant = "n.flores07" 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 = "19473" select * from cotisations where identifiant = "n.flores07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 175520 payment_means : VISA transmission_date : 20161231165520 payment_time : 175714 payment_date : 20161231 response_code : 00 payment_certificate : 540fa3c3204b authorisation_id : 702476 currency_code : 978 card_number : 4970.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 : n.flores07 order_id : 19473 customer_email : n.flores07@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 = "19475" select * from cms_frontusers where identifiant = "m.marc10" 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 = "19475" select * from cotisations where identifiant = "m.marc10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180640 payment_means : VISA transmission_date : 20161231170640 payment_time : 180919 payment_date : 20161231 response_code : 00 payment_certificate : 00987a8f1bcd authorisation_id : 033147 currency_code : 978 card_number : 4970.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.marc10 order_id : 19475 customer_email : m.marc10@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 = "19474" select * from cms_frontusers where identifiant = "e.guaine18" 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 = "19474" select * from cotisations where identifiant = "e.guaine18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180318 payment_means : MASTERCARD transmission_date : 20161231170318 payment_time : 182005 payment_date : 20161231 response_code : 00 payment_certificate : aa67c0694c17 authorisation_id : 913533 currency_code : 978 card_number : 5137.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 : e.guaine18 order_id : 19474 customer_email : e.guaine18@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 = "19476" select * from cms_frontusers where identifiant = "f.vandenbroucque11" 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 = "19476" select * from cotisations where identifiant = "f.vandenbroucque11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181856 payment_means : VISA transmission_date : 20161231171856 payment_time : 182119 payment_date : 20161231 response_code : 00 payment_certificate : bf00a79ec75a authorisation_id : 627167 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.vandenbroucque11 order_id : 19476 customer_email : f.vandenbroucque11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19477" select * from cms_frontusers where identifiant = "v.salvaire04" 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 = "19477" select * from cotisations where identifiant = "v.salvaire04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 182424 payment_means : VISA transmission_date : 20161231172424 payment_time : 182644 payment_date : 20161231 response_code : 00 payment_certificate : 35ec58bcd761 authorisation_id : 135367 currency_code : 978 card_number : 4561.36 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.salvaire04 order_id : 19477 customer_email : v.salvaire04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201810 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19480" select * from cms_frontusers where identifiant = "r.creze20" 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 = "19480" select * from cotisations where identifiant = "r.creze20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185210 payment_means : VISA transmission_date : 20161231175210 payment_time : 185429 payment_date : 20161231 response_code : 00 payment_certificate : 53383748a5a1 authorisation_id : 551047 currency_code : 978 card_number : 4975.22 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.creze20 order_id : 19480 customer_email : r.creze20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19481" select * from cms_frontusers where identifiant = "e.bodenan26" 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 = "19481" select * from cotisations where identifiant = "e.bodenan26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190736 payment_means : VISA transmission_date : 20161231180736 payment_time : 191018 payment_date : 20161231 response_code : 00 payment_certificate : ec3c3d26b101 authorisation_id : 312530 currency_code : 978 card_number : 4976.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 : e.bodenan26 order_id : 19481 customer_email : e.bodenan26@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 = "19482" select * from cms_frontusers where identifiant = "a.fournie06" 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 = "19482" select * from cotisations where identifiant = "l.cenac10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 191109 payment_means : VISA transmission_date : 20161231181109 payment_time : 191246 payment_date : 20161231 response_code : 00 payment_certificate : b346e10137b3 authorisation_id : 520605 currency_code : 978 card_number : 4976.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.fournie06 order_id : 19482 customer_email : a.fournie06@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 = "19483" select * from cms_frontusers where identifiant = "f.buhnemann06" 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 = "19483" select * from cotisations where identifiant = "f.buhnemann06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191842 payment_means : VISA transmission_date : 20161231181842 payment_time : 192020 payment_date : 20161231 response_code : 00 payment_certificate : bd35185cd47a authorisation_id : 201090 currency_code : 978 card_number : 4150.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 : f.buhnemann06 order_id : 19483 customer_email : f.buhnemann06@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 = "19484" select * from cms_frontusers where identifiant = "c.vassas27" 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 = "19484" select * from cotisations where identifiant = "c.vassas27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193737 payment_means : VISA transmission_date : 20161231183737 payment_time : 193907 payment_date : 20161231 response_code : 00 payment_certificate : 21b184c05c3a authorisation_id : 334521 currency_code : 978 card_number : 4970.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.vassas27 order_id : 19484 customer_email : c.vassas27@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 = "19485" select * from cms_frontusers where identifiant = "c.bery10" 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 = "19485" select * from cotisations where identifiant = "c.bery10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195157 payment_means : VISA transmission_date : 20161231185157 payment_time : 195306 payment_date : 20161231 response_code : 00 payment_certificate : 4e68c687c213 authorisation_id : 530402 currency_code : 978 card_number : 4974.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.bery10 order_id : 19485 customer_email : c.bery10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201612 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19486" select * from cms_frontusers where identifiant = "n.mauclert16" 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 = "19486" select * from cotisations where identifiant = "n.mauclert16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195222 payment_means : VISA transmission_date : 20161231185222 payment_time : 195444 payment_date : 20161231 response_code : 00 payment_certificate : ec45d07c0d66 authorisation_id : 711259 currency_code : 978 card_number : 4978.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 : n.mauclert16 order_id : 19486 customer_email : n.mauclert16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19488" select * from cms_frontusers where identifiant = "a.skrzyniak14" 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 = "19488" select * from cotisations where identifiant = "a.skrzyniak14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200114 payment_means : VISA transmission_date : 20161231190114 payment_time : 200343 payment_date : 20161231 response_code : 00 payment_certificate : 1b570dc775eb authorisation_id : 606224 currency_code : 978 card_number : 4533.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.skrzyniak14 order_id : 19488 customer_email : a.skrzyniak14@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 = "19489" select * from cms_frontusers where identifiant = "m.soler06" 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 = "19489" select * from cotisations where identifiant = "m.soler06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200857 payment_means : MASTERCARD transmission_date : 20161231190857 payment_time : 201327 payment_date : 20161231 response_code : 00 payment_certificate : 5a3a5e5ad3b5 authorisation_id : 225619 currency_code : 978 card_number : 5132.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.soler06 order_id : 19489 customer_email : m.soler06@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 = "19490" select * from cms_frontusers where identifiant = "n.georget08" 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 = "19490" select * from cotisations where identifiant = "n.georget08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202008 payment_means : VISA transmission_date : 20161231192008 payment_time : 202157 payment_date : 20161231 response_code : 00 payment_certificate : d5ed0bd83b39 authorisation_id : 525269 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 : n.georget08 order_id : 19490 customer_email : n.georget08@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201902 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19491" select * from cms_frontusers where identifiant = "r.davi09" 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 = "19491" select * from cotisations where identifiant = "r.davi09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204131 payment_means : MASTERCARD transmission_date : 20161231194131 payment_time : 204309 payment_date : 20161231 response_code : 00 payment_certificate : ab728fe3778c authorisation_id : 603324 currency_code : 978 card_number : 5131.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.davi09 order_id : 19491 customer_email : r.davi09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201906 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19493" select * from cms_frontusers where identifiant = "j.demarle05" 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 = "19493" select * from cotisations where identifiant = "j.demarle05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214831 payment_means : MASTERCARD transmission_date : 20161231204831 payment_time : 215035 payment_date : 20161231 response_code : 00 payment_certificate : 5ee3582384fe authorisation_id : 641651 currency_code : 978 card_number : 5131.70 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.demarle05 order_id : 19493 customer_email : j.demarle05@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 : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19494" select * from cms_frontusers where identifiant = "x.gaillard02" 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 = "19494" select * from cotisations where identifiant = "x.gaillard02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220230 payment_means : VISA transmission_date : 20161231210230 payment_time : 220400 payment_date : 20161231 response_code : 00 payment_certificate : 3fde94fdd4f4 authorisation_id : 646252 currency_code : 978 card_number : 4974.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.gaillard02 order_id : 19494 customer_email : x.gaillard02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201907 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 : 225621 payment_means : VISA transmission_date : 20161231215621 payment_time : 225756 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4530.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jb.gil08 order_id : 19495 customer_email : jb.gil08@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 : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19496" select * from cms_frontusers where identifiant = "y.duclos28" 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 = "19496" select * from cotisations where identifiant = "n.bianconi14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225708 payment_means : VISA transmission_date : 20161231215708 payment_time : 225937 payment_date : 20161231 response_code : 00 payment_certificate : 351cc48912c8 authorisation_id : 894541 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 : y.duclos28 order_id : 19496 customer_email : y.duclos28@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 = "19495" select * from cms_frontusers where identifiant = "jb.gil08" 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 = "19495" select * from cotisations where identifiant = "jb.gil08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 225802 payment_means : VISA transmission_date : 20161231215802 payment_time : 230156 payment_date : 20161231 response_code : 00 payment_certificate : b8f7fb9e726b authorisation_id : 031112 currency_code : 978 card_number : 4544.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 : jb.gil08 order_id : 19495 customer_email : jb.gil08@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 : 202007 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 : 225806 payment_means : MASTERCARD transmission_date : 20161231215806 payment_time : 230215 payment_date : 20161231 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.merle15 order_id : 19497 customer_email : c.merle15@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 : 201710 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19500" select * from cms_frontusers where identifiant = "e.lemeur24" 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 = "19500" select * from cotisations where identifiant = "e.lemeur24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 234443 payment_means : VISA transmission_date : 20161231224443 payment_time : 234656 payment_date : 20161231 response_code : 00 payment_certificate : 9ce9efab5781 authorisation_id : 061564 currency_code : 978 card_number : 4970.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 : e.lemeur24 order_id : 19500 customer_email : e.lemeur24@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 = "19499" select * from cms_frontusers where identifiant = "l.vazquez14" 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 = "19499" select * from cotisations where identifiant = "l.vazquez14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 234428 payment_means : MASTERCARD transmission_date : 20161231224428 payment_time : 234747 payment_date : 20161231 response_code : 00 payment_certificate : f8627b52a9ca authorisation_id : 611198 currency_code : 978 card_number : 5132.37 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.vazquez14 order_id : 19499 customer_email : l.vazquez14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201711 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "19501" select * from cms_frontusers where identifiant = "j.guillet27" 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 = "19501" select * from cotisations where identifiant = "j.guillet27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 235341 payment_means : VISA transmission_date : 20161231225341 payment_time : 235550 payment_date : 20161231 response_code : 00 payment_certificate : 61eb7c43cfce authorisation_id : 214494 currency_code : 978 card_number : 4972.35 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.guillet27 order_id : 19501 customer_email : j.guillet27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------