select * from cotisations_commande where id = "20861" select * from cms_frontusers where identifiant = "s.sanchez01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20861" select * from cotisations where identifiant = "s.sanchez01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070739 payment_means : VISA transmission_date : 20170123060739 payment_time : 071017 payment_date : 20170123 response_code : 00 payment_certificate : 6eaec3d80686 authorisation_id : 993483 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 : s.sanchez01 order_id : 20861 customer_email : s.sanchez01@compagnons-du-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 = "20862" select * from cms_frontusers where identifiant = "e.carlac01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20862" select * from cotisations where identifiant = "e.carlac01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082948 payment_means : VISA transmission_date : 20170123072948 payment_time : 083101 payment_date : 20170123 response_code : 00 payment_certificate : b730c91d9345 authorisation_id : 524752 currency_code : 978 card_number : 4979.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 : e.carlac01 order_id : 20862 customer_email : e.carlac01@compagnons-du-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 = "20863" select * from cms_frontusers where identifiant = "n.chagneau15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20863" select * from cotisations where identifiant = "n.chagneau15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 091439 payment_means : VISA transmission_date : 20170123081439 payment_time : 091732 payment_date : 20170123 response_code : 00 payment_certificate : df614ab786b0 authorisation_id : 452986 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 : n.chagneau15 order_id : 20863 customer_email : n.chagneau15@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092021 payment_means : MASTERCARD transmission_date : 20170123082021 payment_time : 092227 payment_date : 20170123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guillou04 order_id : 20865 customer_email : a.guillou04@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20866" select * from cms_frontusers where identifiant = "l.coutant18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20866" select * from cotisations where identifiant = "l.coutant18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092228 payment_means : MASTERCARD transmission_date : 20170123082228 payment_time : 092327 payment_date : 20170123 response_code : 00 payment_certificate : ef4a2dd0ac0e authorisation_id : 446414 currency_code : 978 card_number : 5341.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.coutant18 order_id : 20866 customer_email : l.coutant18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092235 payment_means : MASTERCARD transmission_date : 20170123082235 payment_time : 092424 payment_date : 20170123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guillou04 order_id : 20865 customer_email : a.guillou04@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 : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20865" select * from cms_frontusers where identifiant = "a.guillou04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20865" select * from cotisations where identifiant = "a.guillou04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092430 payment_means : VISA transmission_date : 20170123082430 payment_time : 092736 payment_date : 20170123 response_code : 00 payment_certificate : 3d5e5a537252 authorisation_id : 556510 currency_code : 978 card_number : 4977.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 : a.guillou04 order_id : 20865 customer_email : a.guillou04@compagnons-du-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 = "20864" select * from cms_frontusers where identifiant = "t.vanexem24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20864" select * from cotisations where identifiant = "t.vanexem24" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "b.bricaud19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 091927 payment_means : VISA transmission_date : 20170123081927 payment_time : 092950 payment_date : 20170123 response_code : 00 payment_certificate : ceb4c443275f authorisation_id : 395393 currency_code : 978 card_number : 4978.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 : t.vanexem24 order_id : 20864 customer_email : t.vanexem24@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094050 payment_means : VISA transmission_date : 20170123084050 payment_time : 094219 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.landais10 order_id : 20867 customer_email : s.landais10@compagnons-du-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 = "20868" select * from cms_frontusers where identifiant = "jp.contin28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20868" select * from cotisations where identifiant = "jp.contin28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101031 payment_means : MASTERCARD transmission_date : 20170123091031 payment_time : 101211 payment_date : 20170123 response_code : 00 payment_certificate : e76980cc742d authorisation_id : 390431 currency_code : 978 card_number : 5137.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 : jp.contin28 order_id : 20868 customer_email : jp.contin28@compagnons-du-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 = "20869" select * from cms_frontusers where identifiant = "v.boulin29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20869" select * from cotisations where identifiant = "n.nollet08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102953 payment_means : VISA transmission_date : 20170123092953 payment_time : 103156 payment_date : 20170123 response_code : 00 payment_certificate : ead5fc2e40ca authorisation_id : 671154 currency_code : 978 card_number : 4974.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.boulin29 order_id : 20869 customer_email : v.boulin29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20870" select * from cms_frontusers where identifiant = "m.brun03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20870" select * from cotisations where identifiant = "m.brun03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 103040 payment_means : MASTERCARD transmission_date : 20170123093040 payment_time : 103336 payment_date : 20170123 response_code : 00 payment_certificate : fda39cd3a353 authorisation_id : 241525 currency_code : 978 card_number : 5132.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 : m.brun03 order_id : 20870 customer_email : m.brun03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20871" select * from cms_frontusers where identifiant = "j.boutefeu31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20871" select * from cotisations where identifiant = "j.boutefeu31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104009 payment_means : VISA transmission_date : 20170123094009 payment_time : 104145 payment_date : 20170123 response_code : 00 payment_certificate : b1d40c141220 authorisation_id : 429282 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 : j.boutefeu31 order_id : 20871 customer_email : j.boutefeu31@compagnons-du-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 = "20872" select * from cms_frontusers where identifiant = "g.puisais09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20872" select * from cotisations where identifiant = "g.puisais09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 104949 payment_means : VISA transmission_date : 20170123094949 payment_time : 105303 payment_date : 20170123 response_code : 00 payment_certificate : f933344e4bb8 authorisation_id : 821947 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 : g.puisais09 order_id : 20872 customer_email : g.puisais09@compagnons-du-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 = "20873" select * from cms_frontusers where identifiant = "y.mateos25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20873" select * from cotisations where identifiant = "y.mateos25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112139 payment_means : VISA transmission_date : 20170123102139 payment_time : 112845 payment_date : 20170123 response_code : 00 payment_certificate : ec3ed6ef8553 authorisation_id : 422218 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 : y.mateos25 order_id : 20873 customer_email : y.mateos25@compagnons-du-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 = "20874" select * from cms_frontusers where identifiant = "a.aubin21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20874" select * from cotisations where identifiant = "a.aubin21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 115449 payment_means : MASTERCARD transmission_date : 20170123105449 payment_time : 115621 payment_date : 20170123 response_code : 00 payment_certificate : b02c562e178a authorisation_id : 153050 currency_code : 978 card_number : 5138.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 : a.aubin21 order_id : 20874 customer_email : a.aubin21@compagnons-du-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 = "20877" select * from cms_frontusers where identifiant = "g.amphoux16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20877" select * from cotisations where identifiant = "g.amphoux16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123838 payment_means : MASTERCARD transmission_date : 20170123113838 payment_time : 123944 payment_date : 20170123 response_code : 00 payment_certificate : 84a9c7410851 authorisation_id : 361244 currency_code : 978 card_number : 5132.02 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.amphoux16 order_id : 20877 customer_email : g.amphoux16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20878" select * from cms_frontusers where identifiant = "f.letrange09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20878" select * from cotisations where identifiant = "f.letrange09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130033 payment_means : VISA transmission_date : 20170123120033 payment_time : 130319 payment_date : 20170123 response_code : 00 payment_certificate : 8ac12c519cad authorisation_id : 161842 currency_code : 978 card_number : 4533.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 : f.letrange09 order_id : 20878 customer_email : f.letrange09@compagnons-du-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 = "20880" select * from cms_frontusers where identifiant = "c.maillet14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20880" select * from cotisations where identifiant = "c.maillet14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 131424 payment_means : VISA transmission_date : 20170123121424 payment_time : 131718 payment_date : 20170123 response_code : 00 payment_certificate : 1373d4b21dd2 authorisation_id : 226233 currency_code : 978 card_number : 4533.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 : c.maillet14 order_id : 20880 customer_email : c.maillet14@compagnons-du-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 = "20881" select * from cms_frontusers where identifiant = "g.fagot22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20881" select * from cotisations where identifiant = "g.fagot22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 132352 payment_means : MASTERCARD transmission_date : 20170123122352 payment_time : 132614 payment_date : 20170123 response_code : 00 payment_certificate : 45f3fa0a2828 authorisation_id : 043222 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 : g.fagot22 order_id : 20881 customer_email : g.fagot22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201802 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20882" select * from cms_frontusers where identifiant = "s.pichot01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20882" select * from cotisations where identifiant = "s.pichot01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 145332 payment_means : VISA transmission_date : 20170123135332 payment_time : 145445 payment_date : 20170123 response_code : 00 payment_certificate : 8afa95d9fcb1 authorisation_id : 588633 currency_code : 978 card_number : 4974.25 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.pichot01 order_id : 20882 customer_email : s.pichot01@compagnons-du-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 = "20884" select * from cms_frontusers where identifiant = "a.laurain03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20884" select * from cotisations where identifiant = "a.laurain03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 151205 payment_means : MASTERCARD transmission_date : 20170123141205 payment_time : 151403 payment_date : 20170123 response_code : 00 payment_certificate : 365f15d83b27 authorisation_id : 143380 currency_code : 978 card_number : 5138.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 : a.laurain03 order_id : 20884 customer_email : a.laurain03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20885" select * from cms_frontusers where identifiant = "e.szczuczynski31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20885" select * from cotisations where identifiant = "e.szczuczynski31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 151357 payment_means : VISA transmission_date : 20170123141357 payment_time : 151617 payment_date : 20170123 response_code : 00 payment_certificate : 334fd0206939 authorisation_id : 322329 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 : e.szczuczynski31 order_id : 20885 customer_email : e.szczuczynski31@compagnons-du-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 = "20886" select * from cms_frontusers where identifiant = "q.houles18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20886" select * from cotisations where identifiant = "q.houles18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 154134 payment_means : VISA transmission_date : 20170123144134 payment_time : 154426 payment_date : 20170123 response_code : 00 payment_certificate : f117ea89bc8f authorisation_id : 661616 currency_code : 978 card_number : 4978.89 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : q.houles18 order_id : 20886 customer_email : q.houles18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 202001 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20887" select * from cms_frontusers where identifiant = "g1.jezequel27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20887" select * from cotisations where identifiant = "g1.jezequel27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155045 payment_means : MASTERCARD transmission_date : 20170123145045 payment_time : 155448 payment_date : 20170123 response_code : 00 payment_certificate : 458bdfa49cff authorisation_id : 088151 currency_code : 978 card_number : 5131.69 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g1.jezequel27 order_id : 20887 customer_email : g1.jezequel27@compagnons-du-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 = "20888" select * from cms_frontusers where identifiant = "b.pondaven11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20888" select * from cotisations where identifiant = "b.pondaven11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 155551 payment_means : MASTERCARD transmission_date : 20170123145551 payment_time : 155821 payment_date : 20170123 response_code : 00 payment_certificate : 9eef4800716a authorisation_id : 787635 currency_code : 978 card_number : 5130.26 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.pondaven11 order_id : 20888 customer_email : b.pondaven11@compagnons-du-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 = "20889" select * from cms_frontusers where identifiant = "c.laville19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20889" select * from cotisations where identifiant = "c.laville19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161005 payment_means : MASTERCARD transmission_date : 20170123151005 payment_time : 161212 payment_date : 20170123 response_code : 00 payment_certificate : 0c8d3f3444b4 authorisation_id : 187406 currency_code : 978 card_number : 5131.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.laville19 order_id : 20889 customer_email : c.laville19@compagnons-du-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 = "20891" select * from cms_frontusers where identifiant = "e.renard25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20891" select * from cotisations where identifiant = "e.renard25" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "e.renard25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171232 payment_means : MASTERCARD transmission_date : 20170123161232 payment_time : 171457 payment_date : 20170123 response_code : 00 payment_certificate : 268e174bfb4a authorisation_id : 593532 currency_code : 978 card_number : 5131.79 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.renard25 order_id : 20891 customer_email : e.renard25@compagnons-du-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 = "20892" select * from cms_frontusers where identifiant = "a.perreau16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20892" select * from cotisations where identifiant = "a.perreau16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 173538 payment_means : VISA transmission_date : 20170123163538 payment_time : 173838 payment_date : 20170123 response_code : 00 payment_certificate : 74786f2f9708 authorisation_id : 846405 currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.perreau16 order_id : 20892 customer_email : a.perreau16@compagnons-du-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 = "20893" select * from cms_frontusers where identifiant = "a.perreau16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20893" select * from cotisations where identifiant = "a.perreau16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 174028 payment_means : VISA transmission_date : 20170123164028 payment_time : 174150 payment_date : 20170123 response_code : 00 payment_certificate : 114966efeae5 authorisation_id : 936054 currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.perreau16 order_id : 20893 customer_email : a.perreau16@compagnons-du-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 = "20894" select * from cms_frontusers where identifiant = "e.letertre30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20894" select * from cotisations where identifiant = "e.letertre30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180150 payment_means : MASTERCARD transmission_date : 20170123170150 payment_time : 180358 payment_date : 20170123 response_code : 00 payment_certificate : f6105263b013 authorisation_id : 139766 currency_code : 978 card_number : 5133.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 : e.letertre30 order_id : 20894 customer_email : e.letertre30@compagnons-du-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 : 4000 transaction_id : 180308 payment_means : VISA transmission_date : 20170123170308 payment_time : 180429 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : i.cazalis03 order_id : 20895 customer_email : i.cazalis03@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 180442 payment_means : CB transmission_date : 20170123170442 payment_time : 180542 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4976.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : i.cazalis03 order_id : 20895 customer_email : i.cazalis03@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 : 201812 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20896" select * from cms_frontusers where identifiant = "s.gau27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20896" select * from cotisations where identifiant = "s.gau27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182954 payment_means : MASTERCARD transmission_date : 20170123172954 payment_time : 183148 payment_date : 20170123 response_code : 00 payment_certificate : 4edcaac08d50 authorisation_id : 431325 currency_code : 978 card_number : 5131.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.gau27 order_id : 20896 customer_email : s.gau27@compagnons-du-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 = "20897" select * from cms_frontusers where identifiant = "b.guillain03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20897" select * from cotisations where identifiant = "b.guillain03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183002 payment_means : MASTERCARD transmission_date : 20170123173002 payment_time : 183223 payment_date : 20170123 response_code : 00 payment_certificate : 2731b5ccabaa authorisation_id : 427804 currency_code : 978 card_number : 5132.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 : b.guillain03 order_id : 20897 customer_email : b.guillain03@compagnons-du-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 = "20898" select * from cms_frontusers where identifiant = "c.barnouin08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20898" select * from cotisations where identifiant = "c.barnouin08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183304 payment_means : VISA transmission_date : 20170123173304 payment_time : 183621 payment_date : 20170123 response_code : 00 payment_certificate : cef2469bd37e authorisation_id : 111404 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 : c.barnouin08 order_id : 20898 customer_email : c.barnouin08@compagnons-du-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 = "20899" select * from cms_frontusers where identifiant = "p.lequellec25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20899" select * from cotisations where identifiant = "p.lequellec25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184247 payment_means : VISA transmission_date : 20170123174247 payment_time : 184424 payment_date : 20170123 response_code : 00 payment_certificate : 8b88f6c2ac36 authorisation_id : 855644 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 : p.lequellec25 order_id : 20899 customer_email : p.lequellec25@compagnons-du-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 = "20900" select * from cms_frontusers where identifiant = "t.jaunet14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20900" select * from cotisations where identifiant = "t.jaunet14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184314 payment_means : MASTERCARD transmission_date : 20170123174314 payment_time : 184521 payment_date : 20170123 response_code : 00 payment_certificate : 4819c17e1efd authorisation_id : 362163 currency_code : 978 card_number : 5132.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 : t.jaunet14 order_id : 20900 customer_email : t.jaunet14@compagnons-du-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 : 4000 transaction_id : 184545 payment_means : MASTERCARD transmission_date : 20170123174545 payment_time : 184720 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.41 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.jaunet14 order_id : 20901 customer_email : t.jaunet14@compagnons-du-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 = "20901" select * from cms_frontusers where identifiant = "t.jaunet14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20901" select * from cotisations where identifiant = "t.jaunet14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 184804 payment_means : MASTERCARD transmission_date : 20170123174804 payment_time : 184958 payment_date : 20170123 response_code : 00 payment_certificate : 1655a7ab1ebc authorisation_id : 124065 currency_code : 978 card_number : 5132.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 : t.jaunet14 order_id : 20901 customer_email : t.jaunet14@compagnons-du-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 = "20902" select * from cms_frontusers where identifiant = "p.cabaret22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20902" select * from cotisations where identifiant = "p.cabaret22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 184824 payment_means : VISA transmission_date : 20170123174824 payment_time : 185031 payment_date : 20170123 response_code : 00 payment_certificate : 9f2e35c4d9e8 authorisation_id : 331112 currency_code : 978 card_number : 4975.45 cvv_flag : 1 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.cabaret22 order_id : 20902 customer_email : p.cabaret22@compagnons-du-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 = "20904" select * from cms_frontusers where identifiant = "y.duhal14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20904" select * from cotisations where identifiant = "j.berna16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190326 payment_means : VISA transmission_date : 20170123180326 payment_time : 190452 payment_date : 20170123 response_code : 00 payment_certificate : c253cb2b8e57 authorisation_id : 545740 currency_code : 978 card_number : 4975.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 : y.duhal14 order_id : 20904 customer_email : y.duhal14@compagnons-du-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 = "20903" select * from cms_frontusers where identifiant = "p.portail25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20903" select * from cotisations where identifiant = "p.portail25" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "p.portail23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 12000 transaction_id : 190231 payment_means : MASTERCARD transmission_date : 20170123180231 payment_time : 190539 payment_date : 20170123 response_code : 00 payment_certificate : 85dc5a688e56 authorisation_id : 670560 currency_code : 978 card_number : 5131.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 : p.portail25 order_id : 20903 customer_email : p.portail25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190702 payment_means : VISA transmission_date : 20170123180702 payment_time : 190951 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.22 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 : m.rolandgosselin03 order_id : 20905 customer_email : m.rolandgosselin03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191020 payment_means : VISA transmission_date : 20170123181020 payment_time : 191209 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.22 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 : m.rolandgosselin03 order_id : 20905 customer_email : m.rolandgosselin03@compagnons-du-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 = "20906" select * from cms_frontusers where identifiant = "m.thiebault19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20906" select * from cotisations where identifiant = "m.thiebault19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191239 payment_means : MASTERCARD transmission_date : 20170123181239 payment_time : 191339 payment_date : 20170123 response_code : 00 payment_certificate : 4a8d577d737a authorisation_id : 152084 currency_code : 978 card_number : 5131.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 : m.thiebault19 order_id : 20906 customer_email : m.thiebault19@compagnons-du-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 = "20907" select * from cms_frontusers where identifiant = "m.thiebault19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20907" select * from cotisations where identifiant = "m.thiebault19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191532 payment_means : MASTERCARD transmission_date : 20170123181532 payment_time : 191630 payment_date : 20170123 response_code : 00 payment_certificate : 5b2b6eb1a925 authorisation_id : 562456 currency_code : 978 card_number : 5131.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 : m.thiebault19 order_id : 20907 customer_email : m.thiebault19@compagnons-du-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 = "20908" select * from cms_frontusers where identifiant = "r.robert27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20908" select * from cotisations where identifiant = "r.robert27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 192521 payment_means : VISA transmission_date : 20170123182521 payment_time : 192654 payment_date : 20170123 response_code : 00 payment_certificate : e51822cbcb25 authorisation_id : 053931 currency_code : 978 card_number : 4979.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.robert27 order_id : 20908 customer_email : r.robert27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194833 payment_means : VISA transmission_date : 20170123184833 payment_time : 195035 payment_date : 20170123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.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 : t.cornet03 order_id : 20909 customer_email : t.cornet03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20909" select * from cms_frontusers where identifiant = "t.cornet03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20909" select * from cotisations where identifiant = "t.cornet03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195050 payment_means : VISA transmission_date : 20170123185050 payment_time : 195206 payment_date : 20170123 response_code : 00 payment_certificate : fe9c7d723484 authorisation_id : 895236 currency_code : 978 card_number : 4978.19 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.cornet03 order_id : 20909 customer_email : t.cornet03@compagnons-du-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 = "20911" select * from cms_frontusers where identifiant = "d.monier02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20911" select * from cotisations where identifiant = "d.monier02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201950 payment_means : VISA transmission_date : 20170123191950 payment_time : 202250 payment_date : 20170123 response_code : 00 payment_certificate : 465b474cb8aa authorisation_id : 879532 currency_code : 978 card_number : 4533.98 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.monier02 order_id : 20911 customer_email : d.monier02@compagnons-du-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 = "20913" select * from cms_frontusers where identifiant = "f.boishu19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20913" select * from cotisations where identifiant = "f.boishu19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203102 payment_means : VISA transmission_date : 20170123193102 payment_time : 203210 payment_date : 20170123 response_code : 00 payment_certificate : e93cabe36c11 authorisation_id : 136684 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 : f.boishu19 order_id : 20913 customer_email : f.boishu19@compagnons-du-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 = "20912" select * from cms_frontusers where identifiant = "y.bouges05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20912" select * from cotisations where identifiant = "y.bouges05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203040 payment_means : MASTERCARD transmission_date : 20170123193040 payment_time : 203541 payment_date : 20170123 response_code : 00 payment_certificate : 90f96fc336b9 authorisation_id : 699351 currency_code : 978 card_number : 5132.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 : y.bouges05 order_id : 20912 customer_email : y.bouges05@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20917" select * from cms_frontusers where identifiant = "a.decorte13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20917" select * from cotisations where identifiant = "a.decorte13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203720 payment_means : MASTERCARD transmission_date : 20170123193720 payment_time : 204049 payment_date : 20170123 response_code : 00 payment_certificate : 3286300cca89 authorisation_id : 617314 currency_code : 978 card_number : 5136.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.decorte13 order_id : 20917 customer_email : a.decorte13@compagnons-du-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 = "20918" select * from cms_frontusers where identifiant = "o.belaud25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20918" select * from cotisations where identifiant = "o.belaud25" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "o.belaud25" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203848 payment_means : VISA transmission_date : 20170123193848 payment_time : 204112 payment_date : 20170123 response_code : 00 payment_certificate : 23248394aea6 authorisation_id : 639928 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 : o.belaud25 order_id : 20918 customer_email : o.belaud25@compagnons-du-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 = "20919" select * from cms_frontusers where identifiant = "g.dagorn23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20919" select * from cotisations where identifiant = "d.girault07" and annee = "2017" and montant <> 0 select * from cotisations_commande where id = "20914" select * from cms_frontusers where identifiant = "f.minet10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20914" select * from cotisations where identifiant = "f.minet10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203218 payment_means : MASTERCARD transmission_date : 20170123193218 payment_time : 204611 payment_date : 20170123 response_code : 00 payment_certificate : 365ff745b666 authorisation_id : 503448 currency_code : 978 card_number : 5133.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 : f.minet10 order_id : 20914 customer_email : f.minet10@compagnons-du-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 : ------------------------------------------- code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204059 payment_means : MASTERCARD transmission_date : 20170123194059 payment_time : 204246 payment_date : 20170123 response_code : 00 payment_certificate : 40918a91de2a authorisation_id : 440441 currency_code : 978 card_number : 5137.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.dagorn23 order_id : 20919 customer_email : g.dagorn23@compagnons-du-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 = "20921" select * from cms_frontusers where identifiant = "v.hazac30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20921" select * from cotisations where identifiant = "v.hazac30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204726 payment_means : MASTERCARD transmission_date : 20170123194726 payment_time : 204935 payment_date : 20170123 response_code : 00 payment_certificate : b3ddad3afef7 authorisation_id : 379245 currency_code : 978 card_number : 5131.18 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.hazac30 order_id : 20921 customer_email : v.hazac30@compagnons-du-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 = "20915" select * from cms_frontusers where identifiant = "t.lorber10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20915" select * from cotisations where identifiant = "t.lorber10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203343 payment_means : MASTERCARD transmission_date : 20170123193343 payment_time : 205054 payment_date : 20170123 response_code : 00 payment_certificate : 624fcd46b94d authorisation_id : 869774 currency_code : 978 card_number : 5817.89 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.lorber10 order_id : 20915 customer_email : t.lorber10@compagnons-du-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 = "20922" select * from cms_frontusers where identifiant = "d.mougin30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20922" select * from cotisations where identifiant = "d.mougin30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204919 payment_means : VISA transmission_date : 20170123194919 payment_time : 205244 payment_date : 20170123 response_code : 00 payment_certificate : d22ffd078bab authorisation_id : 555317 currency_code : 978 card_number : 4974.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.mougin30 order_id : 20922 customer_email : d.mougin30@compagnons-du-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 = "20924" select * from cms_frontusers where identifiant = "b.cuccia26" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20924" select * from cotisations where identifiant = "b.cuccia26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205922 payment_means : VISA transmission_date : 20170123195922 payment_time : 210106 payment_date : 20170123 response_code : 00 payment_certificate : 0fd9caa9d741 authorisation_id : 152431 currency_code : 978 card_number : 4973.65 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : b.cuccia26 order_id : 20924 customer_email : b.cuccia26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201905 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20923" select * from cms_frontusers where identifiant = "s.bensalem04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20923" select * from cotisations where identifiant = "s.bensalem04" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "s.bensalem04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205707 payment_means : VISA transmission_date : 20170123195707 payment_time : 210148 payment_date : 20170123 response_code : 00 payment_certificate : b05cc92b2bce authorisation_id : 633230 currency_code : 978 card_number : 4970.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 : s.bensalem04 order_id : 20923 customer_email : s.bensalem04@compagnons-du-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 : 211429 payment_means : VISA transmission_date : 20170123201429 payment_time : 211937 payment_date : 20170123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.39 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.bissardon29 order_id : 20925 customer_email : c.bissardon29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20927" select * from cms_frontusers where identifiant = "c.bissardon29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20927" select * from cotisations where identifiant = "c.bissardon29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212016 payment_means : VISA transmission_date : 20170123202016 payment_time : 212334 payment_date : 20170123 response_code : 00 payment_certificate : 029224e01642 authorisation_id : 943697 currency_code : 978 card_number : 4970.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.bissardon29 order_id : 20927 customer_email : c.bissardon29@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213352 payment_means : MASTERCARD transmission_date : 20170123203352 payment_time : 213817 payment_date : 20170123 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.blin28 order_id : 20928 customer_email : t.blin28@compagnons-du-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 = "20928" select * from cms_frontusers where identifiant = "t.blin28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20928" select * from cotisations where identifiant = "t.blin28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 213841 payment_means : MASTERCARD transmission_date : 20170123203841 payment_time : 214108 payment_date : 20170123 response_code : 00 payment_certificate : 0788341c9575 authorisation_id : 141258 currency_code : 978 card_number : 5137.03 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.blin28 order_id : 20928 customer_email : t.blin28@compagnons-du-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 = "20932" select * from cms_frontusers where identifiant = "o.dupe04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20932" select * from cotisations where identifiant = "o.dupe04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215032 payment_means : MASTERCARD transmission_date : 20170123205032 payment_time : 215301 payment_date : 20170123 response_code : 00 payment_certificate : f5d72024168b authorisation_id : 461324 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 : o.dupe04 order_id : 20932 customer_email : o.dupe04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214939 payment_means : MASTERCARD transmission_date : 20170123204939 payment_time : 215611 payment_date : 20170123 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.foulon23 order_id : 20931 customer_email : m.foulon23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20931" select * from cms_frontusers where identifiant = "m.foulon23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20931" select * from cotisations where identifiant = "m.foulon23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215626 payment_means : MASTERCARD transmission_date : 20170123205626 payment_time : 215909 payment_date : 20170123 response_code : 00 payment_certificate : 921ea3d7d4aa authorisation_id : 754578 currency_code : 978 card_number : 5131.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.foulon23 order_id : 20931 customer_email : m.foulon23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "20933" select * from cms_frontusers where identifiant = "a.sanchez02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20933" select * from cotisations where identifiant = "a.sanchez02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 220158 payment_means : VISA transmission_date : 20170123210158 payment_time : 220449 payment_date : 20170123 response_code : 00 payment_certificate : 28cfb0b1596e authorisation_id : 146047 currency_code : 978 card_number : 4562.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.sanchez02 order_id : 20933 customer_email : a.sanchez02@compagnons-du-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 = "20942" select * from cms_frontusers where identifiant = "j.cadiou04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20942" select * from cotisations where identifiant = "j.cadiou04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222511 payment_means : MASTERCARD transmission_date : 20170123212511 payment_time : 222650 payment_date : 20170123 response_code : 00 payment_certificate : e46857ff6712 authorisation_id : 132131 currency_code : 978 card_number : 5341.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.cadiou04 order_id : 20942 customer_email : j.cadiou04@compagnons-du-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 = "20943" select * from cms_frontusers where identifiant = "c.leguyvandevelde29" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20943" select * from cotisations where identifiant = "c.leguyvandevelde29" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223016 payment_means : VISA transmission_date : 20170123213016 payment_time : 223139 payment_date : 20170123 response_code : 00 payment_certificate : 6434fce2c556 authorisation_id : 110122 currency_code : 978 card_number : 4978.33 cvv_flag : 1 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.leguyvandevelde29 order_id : 20943 customer_email : c.leguyvandevelde29@compagnons-du-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 = "20945" select * from cms_frontusers where identifiant = "m.autret06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "20945" select * from cotisations where identifiant = "m.autret06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223616 payment_means : VISA transmission_date : 20170123213616 payment_time : 223802 payment_date : 20170123 response_code : 00 payment_certificate : 505fbd0f807d authorisation_id : 552815 currency_code : 978 card_number : 4150.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.autret06 order_id : 20945 customer_email : m.autret06@compagnons-du-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 : -------------------------------------------