select * from cotisations_commande where id = "18764" select * from cms_frontusers where identifiant = "r.piau19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18764" select * from cotisations where identifiant = "r.piau19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 014016 payment_means : VISA transmission_date : 20161220004016 payment_time : 014233 payment_date : 20161220 response_code : 00 payment_certificate : e067d4beabcf authorisation_id : 665040 currency_code : 978 card_number : 4974.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.piau19 order_id : 18764 customer_email : r.piau19@compagnons-du-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 = "18765" select * from cms_frontusers where identifiant = "b.bianchi11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18765" select * from cotisations where identifiant = "b.bianchi11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 015158 payment_means : VISA transmission_date : 20161220005158 payment_time : 015359 payment_date : 20161220 response_code : 00 payment_certificate : 42f53d8d8c96 authorisation_id : 242719 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 : b.bianchi11 order_id : 18765 customer_email : b.bianchi11@compagnons-du-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 = "18766" select * from cms_frontusers where identifiant = "m.peyre09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18766" select * from cotisations where identifiant = "m.peyre09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 054420 payment_means : VISA transmission_date : 20161220044420 payment_time : 054630 payment_date : 20161220 response_code : 00 payment_certificate : 39229ad28366 authorisation_id : 628320 currency_code : 978 card_number : 4978.67 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.peyre09 order_id : 18766 customer_email : m.peyre09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18767" select * from cms_frontusers where identifiant = "a.rauzy12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18767" select * from cotisations where identifiant = "a.rauzy12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 072135 payment_means : MASTERCARD transmission_date : 20161220062135 payment_time : 072319 payment_date : 20161220 response_code : 00 payment_certificate : 42f90a06d12c authorisation_id : 214484 currency_code : 978 card_number : 5131.97 cvv_flag : 1 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.rauzy12 order_id : 18767 customer_email : a.rauzy12@compagnons-du-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 = "18769" select * from cms_frontusers where identifiant = "o.four20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18769" select * from cotisations where identifiant = "o.four20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 080149 payment_means : MASTERCARD transmission_date : 20161220070149 payment_time : 080323 payment_date : 20161220 response_code : 00 payment_certificate : 8b5943aefb8b authorisation_id : 949962 currency_code : 978 card_number : 5132.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 : o.four20 order_id : 18769 customer_email : o.four20@compagnons-du-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 = "18771" select * from cms_frontusers where identifiant = "g.roche31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18771" select * from cotisations where identifiant = "g.roche31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 081810 payment_means : MASTERCARD transmission_date : 20161220071810 payment_time : 082224 payment_date : 20161220 response_code : 00 payment_certificate : 563379566f7c authorisation_id : 932201 currency_code : 978 card_number : 5137.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.roche31 order_id : 18771 customer_email : g.roche31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201912 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18772" select * from cms_frontusers where identifiant = "a.varin02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18772" select * from cotisations where identifiant = "a.varin02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 083125 payment_means : MASTERCARD transmission_date : 20161220073125 payment_time : 083256 payment_date : 20161220 response_code : 00 payment_certificate : 42f110932aa5 authorisation_id : 405440 currency_code : 978 card_number : 5137.93 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.varin02 order_id : 18772 customer_email : a.varin02@compagnons-du-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 = "18774" select * from cms_frontusers where identifiant = "m.gougeon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18774" select * from cotisations where identifiant = "m.gougeon03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084604 payment_means : VISA transmission_date : 20161220074604 payment_time : 084759 payment_date : 20161220 response_code : 00 payment_certificate : e93d5785e73a authorisation_id : 566320 currency_code : 978 card_number : 4974.32 cvv_flag : 1 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.gougeon03 order_id : 18774 customer_email : m.gougeon03@compagnons-du-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 = "18773" select * from cms_frontusers where identifiant = "jl.gobbo21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18773" select * from cotisations where identifiant = "jl.gobbo21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 084557 payment_means : VISA transmission_date : 20161220074557 payment_time : 084915 payment_date : 20161220 response_code : 00 payment_certificate : b28d795efca0 authorisation_id : 094754 currency_code : 978 card_number : 4971.73 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jl.gobbo21 order_id : 18773 customer_email : jl.gobbo21@compagnons-du-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 = "18775" select * from cms_frontusers where identifiant = "jj.debortoli31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18775" select * from cotisations where identifiant = "jj.debortoli31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090826 payment_means : VISA transmission_date : 20161220080826 payment_time : 091059 payment_date : 20161220 response_code : 00 payment_certificate : 5dcca531e322 authorisation_id : 263366 currency_code : 978 card_number : 4561.71 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jj.debortoli31 order_id : 18775 customer_email : jj.debortoli31@compagnons-du-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 = "18776" select * from cms_frontusers where identifiant = "al.roty08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18776" select * from cotisations where identifiant = "al.roty08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093805 payment_means : VISA transmission_date : 20161220083805 payment_time : 094114 payment_date : 20161220 response_code : 00 payment_certificate : df4e506b60d5 authorisation_id : 763945 currency_code : 978 card_number : 4973.93 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : al.roty08 order_id : 18776 customer_email : al.roty08@compagnons-du-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 = "18777" select * from cms_frontusers where identifiant = "j.charles19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18777" select * from cotisations where identifiant = "j.charles19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 094452 payment_means : MASTERCARD transmission_date : 20161220084452 payment_time : 094607 payment_date : 20161220 response_code : 00 payment_certificate : 8aadcd1fb791 authorisation_id : 472815 currency_code : 978 card_number : 5137.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.charles19 order_id : 18777 customer_email : j.charles19@compagnons-du-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 = "18778" select * from cms_frontusers where identifiant = "a.ferrand13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18778" select * from cotisations where identifiant = "a.ferrand13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095712 payment_means : MASTERCARD transmission_date : 20161220085712 payment_time : 095906 payment_date : 20161220 response_code : 00 payment_certificate : b45a16ee715e authorisation_id : 564496 currency_code : 978 card_number : 5132.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.ferrand13 order_id : 18778 customer_email : a.ferrand13@compagnons-du-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 = "18779" select * from cms_frontusers where identifiant = "j.guerisse10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18779" select * from cotisations where identifiant = "j.guerisse10" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 095827 payment_means : VISA transmission_date : 20161220085827 payment_time : 095953 payment_date : 20161220 response_code : 00 payment_certificate : 2449e134f12a authorisation_id : 338558 currency_code : 978 card_number : 4974.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.guerisse10 order_id : 18779 customer_email : j.guerisse10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201911 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 102213 payment_means : MASTERCARD transmission_date : 20161220092213 payment_time : 102602 payment_date : 20161220 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.44 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 : v.doussau17 order_id : 18780 customer_email : v.doussau17@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 : 201712 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18780" select * from cms_frontusers where identifiant = "v.doussau17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18780" select * from cotisations where identifiant = "v.doussau17" and annee = "2017" and montant <> 0 select * from cotisations where identifiant = "y.dousseau04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 102612 payment_means : MASTERCARD transmission_date : 20161220092612 payment_time : 102723 payment_date : 20161220 response_code : 00 payment_certificate : 79278bd26910 authorisation_id : 183232 currency_code : 978 card_number : 5137.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 : v.doussau17 order_id : 18780 customer_email : v.doussau17@compagnons-du-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 = "18781" select * from cms_frontusers where identifiant = "d.billaud01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18781" select * from cotisations where identifiant = "d.billaud01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105353 payment_means : MASTERCARD transmission_date : 20161220095353 payment_time : 105616 payment_date : 20161220 response_code : 00 payment_certificate : c0b826e40582 authorisation_id : 532603 currency_code : 978 card_number : 5137.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 : d.billaud01 order_id : 18781 customer_email : d.billaud01@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111905 payment_means : VISA transmission_date : 20161220101905 payment_time : 112448 payment_date : 20161220 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4977.63 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 : d.bordet22 order_id : 18782 customer_email : d.bordet22@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18782" select * from cms_frontusers where identifiant = "d.bordet22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18782" select * from cotisations where identifiant = "d.bordet22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 112457 payment_means : VISA transmission_date : 20161220102457 payment_time : 112825 payment_date : 20161220 response_code : 00 payment_certificate : f26c391835f1 authorisation_id : 368288 currency_code : 978 card_number : 4970.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 : d.bordet22 order_id : 18782 customer_email : d.bordet22@compagnons-du-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 = "18783" select * from cms_frontusers where identifiant = "a.mathevet28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18783" select * from cotisations where identifiant = "a.mathevet28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 115817 payment_means : VISA transmission_date : 20161220105817 payment_time : 120012 payment_date : 20161220 response_code : 00 payment_certificate : cc85ff8c2cb8 authorisation_id : 011430 currency_code : 978 card_number : 4970.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.mathevet28 order_id : 18783 customer_email : a.mathevet28@compagnons-du-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 = "18785" select * from cms_frontusers where identifiant = "l.maitre15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18785" select * from cotisations where identifiant = "j.paumard30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121305 payment_means : VISA transmission_date : 20161220111305 payment_time : 121727 payment_date : 20161220 response_code : 00 payment_certificate : 2dc4677e1fcc authorisation_id : 196672 currency_code : 978 card_number : 4533.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.maitre15 order_id : 18785 customer_email : l.maitre15@compagnons-du-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 = "18786" select * from cms_frontusers where identifiant = "j.budor30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18786" select * from cotisations where identifiant = "j.budor30" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 123017 payment_means : VISA transmission_date : 20161220113017 payment_time : 123216 payment_date : 20161220 response_code : 00 payment_certificate : 109d884ac5e8 authorisation_id : 174413 currency_code : 978 card_number : 4974.68 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.budor30 order_id : 18786 customer_email : j.budor30@compagnons-du-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 = "18787" select * from cms_frontusers where identifiant = "l.maitre15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18787" select * from cotisations where identifiant = "l.maitre15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124159 payment_means : VISA transmission_date : 20161220114159 payment_time : 124423 payment_date : 20161220 response_code : 00 payment_certificate : 3d127608c19d authorisation_id : 460916 currency_code : 978 card_number : 4974.42 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.maitre15 order_id : 18787 customer_email : l.maitre15@compagnons-du-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 = "18788" select * from cms_frontusers where identifiant = "j.belleau15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18788" select * from cotisations where identifiant = "j.belleau15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 144322 payment_means : MASTERCARD transmission_date : 20161220134322 payment_time : 144629 payment_date : 20161220 response_code : 00 payment_certificate : 6274098fdf6f authorisation_id : 955845 currency_code : 978 card_number : 5131.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 : j.belleau15 order_id : 18788 customer_email : j.belleau15@compagnons-du-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 = "18789" select * from cms_frontusers where identifiant = "h.jourdain14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18789" select * from cotisations where identifiant = "h.jourdain14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145606 payment_means : MASTERCARD transmission_date : 20161220135606 payment_time : 150032 payment_date : 20161220 response_code : 00 payment_certificate : 803b33199fed authorisation_id : 294326 currency_code : 978 card_number : 5131.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.jourdain14 order_id : 18789 customer_email : h.jourdain14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201901 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 155538 payment_means : MASTERCARD transmission_date : 20161220145538 payment_time : 155644 payment_date : 20161220 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5135.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.obajdin16 order_id : 18790 customer_email : d.obajdin16@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 = "18791" select * from cms_frontusers where identifiant = "j.hamelin03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18791" select * from cotisations where identifiant = "j.hamelin03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161954 payment_means : MASTERCARD transmission_date : 20161220151954 payment_time : 162239 payment_date : 20161220 response_code : 00 payment_certificate : 809ca8afe198 authorisation_id : 401618 currency_code : 978 card_number : 5131.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 : j.hamelin03 order_id : 18791 customer_email : j.hamelin03@compagnons-du-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 = "18792" select * from cms_frontusers where identifiant = "d.vion16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18792" select * from cotisations where identifiant = "d.vion16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 163454 payment_means : MASTERCARD transmission_date : 20161220153454 payment_time : 164026 payment_date : 20161220 response_code : 00 payment_certificate : faa4f2aa04f9 authorisation_id : 266124 currency_code : 978 card_number : 5135.62 cvv_flag : 1 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.vion16 order_id : 18792 customer_email : d.vion16@compagnons-du-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 = "18793" select * from cms_frontusers where identifiant = "b.cravallee01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18793" select * from cotisations where identifiant = "j.montaret12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 171322 payment_means : VISA transmission_date : 20161220161322 payment_time : 171538 payment_date : 20161220 response_code : 00 payment_certificate : 1fb7ef29549d authorisation_id : 438863 currency_code : 978 card_number : 4533.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 : b.cravallee01 order_id : 18793 customer_email : b.cravallee01@compagnons-du-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 = "18794" select * from cms_frontusers where identifiant = "a.leboucher24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18794" select * from cotisations where identifiant = "a.leboucher24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174826 payment_means : VISA transmission_date : 20161220164826 payment_time : 175052 payment_date : 20161220 response_code : 00 payment_certificate : 226c11f8679d authorisation_id : 160441 currency_code : 978 card_number : 4977.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 : a.leboucher24 order_id : 18794 customer_email : a.leboucher24@compagnons-du-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 = "18795" select * from cms_frontusers where identifiant = "jc.robin12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18795" select * from cotisations where identifiant = "jc.robin12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182522 payment_means : VISA transmission_date : 20161220172522 payment_time : 182904 payment_date : 20161220 response_code : 00 payment_certificate : 5ffb700b99bf authorisation_id : 913693 currency_code : 978 card_number : 4533.20 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.robin12 order_id : 18795 customer_email : jc.robin12@compagnons-du-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 = "18796" select * from cms_frontusers where identifiant = "r.baudet27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18796" select * from cotisations where identifiant = "r.baudet27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183209 payment_means : VISA transmission_date : 20161220173209 payment_time : 183357 payment_date : 20161220 response_code : 00 payment_certificate : 072eeb0aced8 authorisation_id : 315965 currency_code : 978 card_number : 4970.50 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.baudet27 order_id : 18796 customer_email : r.baudet27@compagnons-du-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 : 184917 payment_means : VISA transmission_date : 20161220174917 payment_time : 185409 payment_date : 20161220 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4147.77 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 : e.perrot14 order_id : 18798 customer_email : e.perrot14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 202006 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18798" select * from cms_frontusers where identifiant = "e.perrot14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18798" select * from cotisations where identifiant = "e.perrot14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185515 payment_means : VISA transmission_date : 20161220175515 payment_time : 185553 payment_date : 20161220 response_code : 00 payment_certificate : b604c8340019 authorisation_id : 06610D currency_code : 978 card_number : 4147.77 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.perrot14 order_id : 18798 customer_email : e.perrot14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 202006 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18799" select * from cms_frontusers where identifiant = "s.jaussaud08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18799" select * from cotisations where identifiant = "s.jaussaud08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 190043 payment_means : VISA transmission_date : 20161220180043 payment_time : 190619 payment_date : 20161220 response_code : 00 payment_certificate : 1478a06bde15 authorisation_id : 127259 currency_code : 978 card_number : 4970.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 : s.jaussaud08 order_id : 18799 customer_email : s.jaussaud08@compagnons-du-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 = "18800" select * from cms_frontusers where identifiant = "n.mendonca06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18800" select * from cotisations where identifiant = "n.mendonca06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191101 payment_means : MASTERCARD transmission_date : 20161220181101 payment_time : 191219 payment_date : 20161220 response_code : 00 payment_certificate : eb9c46a5cea0 authorisation_id : 198123 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 : n.mendonca06 order_id : 18800 customer_email : n.mendonca06@compagnons-du-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 = "18801" select * from cms_frontusers where identifiant = "b.guichard07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18801" select * from cotisations where identifiant = "b.guichard07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 191321 payment_means : VISA transmission_date : 20161220181321 payment_time : 191443 payment_date : 20161220 response_code : 00 payment_certificate : 640d79b93d30 authorisation_id : 020603 currency_code : 978 card_number : 4921.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 : b.guichard07 order_id : 18801 customer_email : b.guichard07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201908 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18802" select * from cms_frontusers where identifiant = "p.leveque18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18802" select * from cotisations where identifiant = "p.leveque18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191846 payment_means : MASTERCARD transmission_date : 20161220181846 payment_time : 192135 payment_date : 20161220 response_code : 00 payment_certificate : 173d8d21cccf authorisation_id : 441729 currency_code : 978 card_number : 5130.40 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.leveque18 order_id : 18802 customer_email : p.leveque18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201702 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18803" select * from cms_frontusers where identifiant = "r.dutertre16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18803" select * from cotisations where identifiant = "r.dutertre16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193149 payment_means : MASTERCARD transmission_date : 20161220183149 payment_time : 193519 payment_date : 20161220 response_code : 00 payment_certificate : 0f88523146e2 authorisation_id : 522497 currency_code : 978 card_number : 5132.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.dutertre16 order_id : 18803 customer_email : r.dutertre16@compagnons-du-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 = "18804" select * from cms_frontusers where identifiant = "y.cuenot25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18804" select * from cotisations where identifiant = "c.bergamelli26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 193522 payment_means : MASTERCARD transmission_date : 20161220183522 payment_time : 194148 payment_date : 20161220 response_code : 00 payment_certificate : 0373d8fa93b9 authorisation_id : 640016 currency_code : 978 card_number : 5136.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 : y.cuenot25 order_id : 18804 customer_email : y.cuenot25@compagnons-du-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 = "18805" select * from cms_frontusers where identifiant = "b.carmellinodibon18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18805" select * from cotisations where identifiant = "b.carmellinodibon18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194234 payment_means : VISA transmission_date : 20161220184234 payment_time : 194458 payment_date : 20161220 response_code : 00 payment_certificate : df69c82dd2d5 authorisation_id : 656523 currency_code : 978 card_number : 4973.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 : b.carmellinodibon18 order_id : 18805 customer_email : b.carmellinodibon18@compagnons-du-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 = "18806" select * from cms_frontusers where identifiant = "o.sechet18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18806" select * from cotisations where identifiant = "o.sechet18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 194712 payment_means : MASTERCARD transmission_date : 20161220184712 payment_time : 194825 payment_date : 20161220 response_code : 00 payment_certificate : e6c9bfa93174 authorisation_id : 418606 currency_code : 978 card_number : 5131.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 : o.sechet18 order_id : 18806 customer_email : o.sechet18@compagnons-du-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 = "18807" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18807" select * from cotisations where identifiant = "a.guignon03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195004 payment_means : VISA transmission_date : 20161220185004 payment_time : 195054 payment_date : 20161220 response_code : 00 payment_certificate : 063f8a949bef authorisation_id : 055013 currency_code : 978 card_number : 4207.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 : a.guignon03 order_id : 18807 customer_email : a.guignon03@compagnons-du-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 : 195244 payment_means : VISA transmission_date : 20161220185244 payment_time : 195337 payment_date : 20161220 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4029.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guignon03 order_id : 18808 customer_email : a.guignon03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 202004 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 : 195441 payment_means : VISA transmission_date : 20161220185441 payment_time : 195541 payment_date : 20161220 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4207.43 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guignon03 order_id : 18808 customer_email : a.guignon03@compagnons-du-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 = "18809" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18809" select * from cotisations where identifiant = "j.dupont09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195627 payment_means : VISA transmission_date : 20161220185627 payment_time : 195749 payment_date : 20161220 response_code : 00 payment_certificate : 2d711479d001 authorisation_id : 944484 currency_code : 978 card_number : 4561.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 : a.guignon03 order_id : 18809 customer_email : a.guignon03@compagnons-du-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 = "18810" select * from cms_frontusers where identifiant = "c.masson02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18810" select * from cotisations where identifiant = "c.masson02" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195641 payment_means : MASTERCARD transmission_date : 20161220185641 payment_time : 195815 payment_date : 20161220 response_code : 00 payment_certificate : ab9a299aa0c3 authorisation_id : 163724 currency_code : 978 card_number : 5136.95 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.masson02 order_id : 18810 customer_email : c.masson02@compagnons-du-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 = "18811" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18811" select * from cotisations where identifiant = "t.afflard03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195928 payment_means : MASTERCARD transmission_date : 20161220185928 payment_time : 200031 payment_date : 20161220 response_code : 00 payment_certificate : 213031a3d483 authorisation_id : 877678 currency_code : 978 card_number : 5262.76 cvv_flag : 1 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.guignon03 order_id : 18811 customer_email : a.guignon03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 202102 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18812" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18812" select * from cotisations where identifiant = "y.leclaire31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200210 payment_means : VISA transmission_date : 20161220190210 payment_time : 200446 payment_date : 20161220 response_code : 00 payment_certificate : d3c70ce3b0c1 authorisation_id : 07009B currency_code : 978 card_number : 4400.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guignon03 order_id : 18812 customer_email : a.guignon03@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ATTEMPT statement_reference : card_validity : 201908 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 : 200709 payment_means : VISA transmission_date : 20161220190709 payment_time : 200800 payment_date : 20161220 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4207.92 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 05 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.guignon03 order_id : 18814 customer_email : a.guignon03@compagnons-du-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 = "18815" select * from cms_frontusers where identifiant = "g.donnini11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18815" select * from cotisations where identifiant = "g.donnini11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200750 payment_means : VISA transmission_date : 20161220190750 payment_time : 200932 payment_date : 20161220 response_code : 00 payment_certificate : 2028ff101244 authorisation_id : 313257 currency_code : 978 card_number : 4976.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.donnini11 order_id : 18815 customer_email : g.donnini11@compagnons-du-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 = "18814" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18814" select * from cotisations where identifiant = "aa.martin09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200829 payment_means : VISA transmission_date : 20161220190829 payment_time : 201202 payment_date : 20161220 response_code : 00 payment_certificate : 52aee1f4f48d authorisation_id : 843669 currency_code : 978 card_number : 4561.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 : a.guignon03 order_id : 18814 customer_email : a.guignon03@compagnons-du-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 = "18817" select * from cms_frontusers where identifiant = "a.guignon03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18817" select * from cotisations where identifiant = "r.miellet14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201256 payment_means : VISA transmission_date : 20161220191256 payment_time : 201349 payment_date : 20161220 response_code : 00 payment_certificate : 3c0ffb87f214 authorisation_id : 684745 currency_code : 978 card_number : 4561.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 : a.guignon03 order_id : 18817 customer_email : a.guignon03@compagnons-du-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 = "18819" select * from cms_frontusers where identifiant = "t.lepoutre01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18819" select * from cotisations where identifiant = "a.delvallee05" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.delvallee05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 201457 payment_means : VISA transmission_date : 20161220191457 payment_time : 201648 payment_date : 20161220 response_code : 00 payment_certificate : 8372d5510036 authorisation_id : 274523 currency_code : 978 card_number : 4976.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.lepoutre01 order_id : 18819 customer_email : t.lepoutre01@compagnons-du-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 = "18818" select * from cms_frontusers where identifiant = "c.cot15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18818" select * from cotisations where identifiant = "c.cot15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201338 payment_means : MASTERCARD transmission_date : 20161220191338 payment_time : 201854 payment_date : 20161220 response_code : 00 payment_certificate : 6133489ef268 authorisation_id : 124014 currency_code : 978 card_number : 5131.50 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.cot15 order_id : 18818 customer_email : c.cot15@compagnons-du-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 = "18820" select * from cms_frontusers where identifiant = "j.schietecatte31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18820" select * from cotisations where identifiant = "j.schietecatte31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201802 payment_means : VISA transmission_date : 20161220191802 payment_time : 201924 payment_date : 20161220 response_code : 00 payment_certificate : 6fe5ea687b3d authorisation_id : 688422 currency_code : 978 card_number : 4970.27 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.schietecatte31 order_id : 18820 customer_email : j.schietecatte31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18822" select * from cms_frontusers where identifiant = "m.dumon11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18822" select * from cotisations where identifiant = "m.dumon11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201924 payment_means : MASTERCARD transmission_date : 20161220191924 payment_time : 202043 payment_date : 20161220 response_code : 00 payment_certificate : f9b39f727250 authorisation_id : 321511 currency_code : 978 card_number : 5136.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.dumon11 order_id : 18822 customer_email : m.dumon11@compagnons-du-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 = "18816" select * from cms_frontusers where identifiant = "j.balinha03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18816" select * from cotisations where identifiant = "j.balinha03" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200903 payment_means : VISA transmission_date : 20161220190903 payment_time : 202501 payment_date : 20161220 response_code : 00 payment_certificate : 09594e0d0ea2 authorisation_id : 364033 currency_code : 978 card_number : 4974.20 cvv_flag : 1 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.balinha03 order_id : 18816 customer_email : j.balinha03@compagnons-du-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 = "18824" select * from cms_frontusers where identifiant = "m.affagard18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18824" select * from cotisations where identifiant = "m.affagard18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202620 payment_means : VISA transmission_date : 20161220192620 payment_time : 202910 payment_date : 20161220 response_code : 00 payment_certificate : cf26618d4d13 authorisation_id : 020092 currency_code : 978 card_number : 4921.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 : m.affagard18 order_id : 18824 customer_email : m.affagard18@compagnons-du-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 = "18825" select * from cms_frontusers where identifiant = "v.herbin23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18825" select * from cotisations where identifiant = "v.herbin23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202802 payment_means : VISA transmission_date : 20161220192802 payment_time : 203142 payment_date : 20161220 response_code : 00 payment_certificate : e144b5d2689a authorisation_id : 304631 currency_code : 978 card_number : 4978.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 : v.herbin23 order_id : 18825 customer_email : v.herbin23@compagnons-du-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 = "18826" select * from cms_frontusers where identifiant = "c.godard12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18826" select * from cotisations where identifiant = "c.godard12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203742 payment_means : MASTERCARD transmission_date : 20161220193742 payment_time : 204121 payment_date : 20161220 response_code : 00 payment_certificate : e66c52419e15 authorisation_id : 547755 currency_code : 978 card_number : 5130.96 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.godard12 order_id : 18826 customer_email : c.godard12@compagnons-du-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 = "18827" select * from cms_frontusers where identifiant = "c.moser31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18827" select * from cotisations where identifiant = "c.moser31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205012 payment_means : MASTERCARD transmission_date : 20161220195012 payment_time : 205158 payment_date : 20161220 response_code : 00 payment_certificate : a3d942467b46 authorisation_id : 311794 currency_code : 978 card_number : 5132.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.moser31 order_id : 18827 customer_email : c.moser31@compagnons-du-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 : 205207 payment_means : MASTERCARD transmission_date : 20161220195207 payment_time : 205629 payment_date : 20161220 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : h.vialla07 order_id : 18829 customer_email : h.vialla07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18829" select * from cms_frontusers where identifiant = "h.vialla07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18829" select * from cotisations where identifiant = "h.vialla07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205659 payment_means : MASTERCARD transmission_date : 20161220195659 payment_time : 205929 payment_date : 20161220 response_code : 00 payment_certificate : 9f0587058661 authorisation_id : 844830 currency_code : 978 card_number : 5135.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 : h.vialla07 order_id : 18829 customer_email : h.vialla07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205217 payment_means : MASTERCARD transmission_date : 20161220195217 payment_time : 205939 payment_date : 20161220 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.01 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.richard24 order_id : 18828 customer_email : c.richard24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18830" select * from cms_frontusers where identifiant = "x.voegel31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18830" select * from cotisations where identifiant = "x.voegel31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 210054 payment_means : VISA transmission_date : 20161220200054 payment_time : 210431 payment_date : 20161220 response_code : 00 payment_certificate : a0ca60a4f61f authorisation_id : 262072 currency_code : 978 card_number : 4973.62 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.voegel31 order_id : 18830 customer_email : x.voegel31@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18831" select * from cms_frontusers where identifiant = "p.remy18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18831" select * from cotisations where identifiant = "p.remy18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210428 payment_means : VISA transmission_date : 20161220200428 payment_time : 210809 payment_date : 20161220 response_code : 00 payment_certificate : 27d37ca24e0c authorisation_id : 496433 currency_code : 978 card_number : 4975.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.remy18 order_id : 18831 customer_email : p.remy18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201904 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "18832" select * from cms_frontusers where identifiant = "jb.durand21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18832" select * from cotisations where identifiant = "a.castagno24" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "a.castagno24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 212539 payment_means : VISA transmission_date : 20161220202539 payment_time : 212700 payment_date : 20161220 response_code : 00 payment_certificate : 98602891c5b3 authorisation_id : 281367 currency_code : 978 card_number : 4970.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 : jb.durand21 order_id : 18832 customer_email : jb.durand21@compagnons-du-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 = "18835" select * from cms_frontusers where identifiant = "c.favere25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18835" select * from cotisations where identifiant = "p.llado26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 220901 payment_means : VISA transmission_date : 20161220210901 payment_time : 221018 payment_date : 20161220 response_code : 00 payment_certificate : ba2164fdb56b authorisation_id : 334331 currency_code : 978 card_number : 4978.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.favere25 order_id : 18835 customer_email : c.favere25@compagnons-du-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 = "18836" select * from cms_frontusers where identifiant = "j.bossuet11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18836" select * from cotisations where identifiant = "j.bossuet11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 222123 payment_means : VISA transmission_date : 20161220212123 payment_time : 222316 payment_date : 20161220 response_code : 00 payment_certificate : 2f86ef16ffd0 authorisation_id : 533400 currency_code : 978 card_number : 4978.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.bossuet11 order_id : 18836 customer_email : j.bossuet11@compagnons-du-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 = "18837" select * from cms_frontusers where identifiant = "f.laporte11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "18837" select * from cotisations where identifiant = "f.laporte11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 231145 payment_means : MASTERCARD transmission_date : 20161220221145 payment_time : 231400 payment_date : 20161220 response_code : 00 payment_certificate : c61571bbb5f3 authorisation_id : 464278 currency_code : 978 card_number : 5132.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 : f.laporte11 order_id : 18837 customer_email : f.laporte11@compagnons-du-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 : -------------------------------------------