select * from cotisations_commande where id = "10955" select * from cms_frontusers where identifiant = "x.lombart18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10955" select * from cotisations where identifiant = "x.lombart18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 002148 payment_means : VISA transmission_date : 20151215232148 payment_time : 002544 payment_date : 20151216 response_code : 00 payment_certificate : f570d1d85d64 authorisation_id : 853696 currency_code : 978 card_number : 4970.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : x.lombart18 order_id : 10955 customer_email : x.lombart18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10956" select * from cms_frontusers where identifiant = "r.viault28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10956" select * from cotisations where identifiant = "r.viault28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 070942 payment_means : MASTERCARD transmission_date : 20151216060942 payment_time : 071154 payment_date : 20151216 response_code : 00 payment_certificate : 543caf77a6e2 authorisation_id : 054516 currency_code : 978 card_number : 5137.44 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.viault28 order_id : 10956 customer_email : r.viault28@compagnons-du-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 = "10962" select * from cms_frontusers where identifiant = "p.rosier06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10962" select * from cotisations where identifiant = "p.rosier06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 090314 payment_means : VISA transmission_date : 20151216080314 payment_time : 090538 payment_date : 20151216 response_code : 00 payment_certificate : 43992b8c31e6 authorisation_id : 729241 currency_code : 978 card_number : 4972.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 : p.rosier06 order_id : 10962 customer_email : p.rosier06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201602 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092630 payment_means : MASTERCARD transmission_date : 20151216082630 payment_time : 092827 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.raymond20 order_id : 10965 customer_email : s.raymond20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10966" select * from cms_frontusers where identifiant = "e.germain21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10966" select * from cotisations where identifiant = "e.germain21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092756 payment_means : MASTERCARD transmission_date : 20151216082756 payment_time : 093058 payment_date : 20151216 response_code : 00 payment_certificate : ff2ebd696a25 authorisation_id : 166535 currency_code : 978 card_number : 5131.54 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : e.germain21 order_id : 10966 customer_email : e.germain21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 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 : 095341 payment_means : VISA transmission_date : 20151216085341 payment_time : 095516 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4975.06 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.parzych14 order_id : 10967 customer_email : v.parzych14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201801 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10967" select * from cms_frontusers where identifiant = "v.parzych14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10967" select * from cotisations where identifiant = "v.parzych14" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 095525 payment_means : VISA transmission_date : 20151216085525 payment_time : 095554 payment_date : 20151216 response_code : 00 payment_certificate : 6c19b9934bc5 authorisation_id : 141535 currency_code : 978 card_number : 4975.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 : v.parzych14 order_id : 10967 customer_email : v.parzych14@compagnons-du-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 = "10968" select * from cms_frontusers where identifiant = "d.villedieu17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10968" select * from cotisations where identifiant = "a.guertin25" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 101728 payment_means : VISA transmission_date : 20151216091728 payment_time : 102151 payment_date : 20151216 response_code : 00 payment_certificate : 441a85f7cbb6 authorisation_id : 039683 currency_code : 978 card_number : 4201.78 cvv_flag : 1 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.villedieu17 order_id : 10968 customer_email : d.villedieu17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10969" select * from cms_frontusers where identifiant = "d.espagnat21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10969" select * from cotisations where identifiant = "d.espagnat21" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 105743 payment_means : MASTERCARD transmission_date : 20151216095743 payment_time : 105916 payment_date : 20151216 response_code : 00 payment_certificate : 62b6350a8c4f authorisation_id : 465295 currency_code : 978 card_number : 5137.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.espagnat21 order_id : 10969 customer_email : d.espagnat21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10970" select * from cms_frontusers where identifiant = "d.espagnat21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10970" select * from cotisations where identifiant = "a.deux24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 110209 payment_means : MASTERCARD transmission_date : 20151216100209 payment_time : 110324 payment_date : 20151216 response_code : 00 payment_certificate : e4a9b006d583 authorisation_id : 214712 currency_code : 978 card_number : 5137.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.espagnat21 order_id : 10970 customer_email : d.espagnat21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10971" select * from cms_frontusers where identifiant = "d.goujard17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10971" select * from cotisations where identifiant = "e.hebert05" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111415 payment_means : MASTERCARD transmission_date : 20151216101415 payment_time : 111531 payment_date : 20151216 response_code : 00 payment_certificate : 73d9df155096 authorisation_id : 555721 currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.goujard17 order_id : 10971 customer_email : d.goujard17@compagnons-du-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 = "10972" select * from cms_frontusers where identifiant = "d.goujard17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10972" select * from cotisations where identifiant = "e.hebert05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111814 payment_means : MASTERCARD transmission_date : 20151216101814 payment_time : 111937 payment_date : 20151216 response_code : 00 payment_certificate : edb008b974b0 authorisation_id : 518856 currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.goujard17 order_id : 10972 customer_email : d.goujard17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114233 payment_means : MASTERCARD transmission_date : 20151216104233 payment_time : 114347 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.goujard17 order_id : 10973 customer_email : d.goujard17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121516 payment_means : MASTERCARD transmission_date : 20151216111516 payment_time : 121625 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.goujard17 order_id : 10974 customer_email : d.goujard17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 121807 payment_means : MASTERCARD transmission_date : 20151216111807 payment_time : 122450 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.nicolas10 order_id : 10975 customer_email : j.nicolas10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10975" select * from cms_frontusers where identifiant = "j.nicolas10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10975" select * from cotisations where identifiant = "p.nicolas03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 122538 payment_means : MASTERCARD transmission_date : 20151216112538 payment_time : 122853 payment_date : 20151216 response_code : 00 payment_certificate : b94b1902cf5c authorisation_id : 111425 currency_code : 978 card_number : 5137.23 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.nicolas10 order_id : 10975 customer_email : j.nicolas10@compagnons-du-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 = "10976" select * from cms_frontusers where identifiant = "jp.casala18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10976" select * from cotisations where identifiant = "f.kerberenes28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 125511 payment_means : VISA transmission_date : 20151216115511 payment_time : 125726 payment_date : 20151216 response_code : 00 payment_certificate : 5e1a1670e02b authorisation_id : 943193 currency_code : 978 card_number : 4975.11 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.casala18 order_id : 10976 customer_email : jp.casala18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10977" select * from cms_frontusers where identifiant = "b.belloin12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10977" select * from cotisations where identifiant = "b.belloin12" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130536 payment_means : MASTERCARD transmission_date : 20151216120536 payment_time : 130710 payment_date : 20151216 response_code : 00 payment_certificate : 94aaf5d774d3 authorisation_id : 211193 currency_code : 978 card_number : 5131.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 : b.belloin12 order_id : 10977 customer_email : b.belloin12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 130646 payment_means : MASTERCARD transmission_date : 20151216120646 payment_time : 130911 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.16 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.boulard14 order_id : 10978 customer_email : p.boulard14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141112 payment_means : CB transmission_date : 20151216131112 payment_time : 131250 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.guerin21 order_id : 10981 customer_email : jp.guerin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 141259 payment_means : MASTERCARD transmission_date : 20151216131259 payment_time : 141542 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.guerin21 order_id : 10981 customer_email : jp.guerin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10982" select * from cms_frontusers where identifiant = "n.thuaux08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10982" select * from cotisations where identifiant = "n.thuaux08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 142644 payment_means : VISA transmission_date : 20151216132644 payment_time : 142835 payment_date : 20151216 response_code : 00 payment_certificate : 5e2c53c1bb80 authorisation_id : 004621 currency_code : 978 card_number : 4975.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 : n.thuaux08 order_id : 10982 customer_email : n.thuaux08@compagnons-du-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 : 144625 payment_means : MASTERCARD transmission_date : 20151216134625 payment_time : 145208 payment_date : 20151216 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 : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.guerin21 order_id : 10983 customer_email : jp.guerin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145326 payment_means : MASTERCARD transmission_date : 20151216135326 payment_time : 145643 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.48 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 59 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.guerin21 order_id : 10984 customer_email : jp.guerin21@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10987" select * from cms_frontusers where identifiant = "l.esnault28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10987" select * from cotisations where identifiant = "l.esnault28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150917 payment_means : VISA transmission_date : 20151216140917 payment_time : 151304 payment_date : 20151216 response_code : 00 payment_certificate : aaffd3a5d8bb authorisation_id : 025174 currency_code : 978 card_number : 4978.07 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.esnault28 order_id : 10987 customer_email : l.esnault28@compagnons-du-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 : 8000 transaction_id : 160427 payment_means : VISA transmission_date : 20151216150427 payment_time : 160922 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4974.50 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.laot06 order_id : 10988 customer_email : a.laot06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201804 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10988" select * from cms_frontusers where identifiant = "a.laot06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10988" select * from cotisations where identifiant = "m.renard18" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160933 payment_means : VISA transmission_date : 20151216150933 payment_time : 161048 payment_date : 20151216 response_code : 00 payment_certificate : cc4849f24b42 authorisation_id : 062415 currency_code : 978 card_number : 4974.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 : a.laot06 order_id : 10988 customer_email : a.laot06@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 161141 payment_means : VISA transmission_date : 20151216151141 payment_time : 161745 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.kwiecnak12 order_id : 10989 customer_email : c.kwiecnak12@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201806 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10990" select * from cms_frontusers where identifiant = "j.gac05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10990" select * from cotisations where identifiant = "j.gac05" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164818 payment_means : MASTERCARD transmission_date : 20151216154818 payment_time : 165002 payment_date : 20151216 response_code : 00 payment_certificate : 78ab128a1994 authorisation_id : 613229 currency_code : 978 card_number : 5132.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 : j.gac05 order_id : 10990 customer_email : j.gac05@compagnons-du-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 = "10991" select * from cms_frontusers where identifiant = "m.coquelin06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10991" select * from cotisations where identifiant = "m.coquelin06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 165842 payment_means : MASTERCARD transmission_date : 20151216155842 payment_time : 170115 payment_date : 20151216 response_code : 00 payment_certificate : 39ab21e491e9 authorisation_id : 216260 currency_code : 978 card_number : 5131.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.coquelin06 order_id : 10991 customer_email : m.coquelin06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 170327 payment_means : CB transmission_date : 20151216160327 payment_time : 170514 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5135.37 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.coquelin06 order_id : 10992 customer_email : m.coquelin06@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_NOTENROLLED statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "10993" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10993" select * from cotisations where identifiant = "p.lefebvre06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172653 payment_means : VISA transmission_date : 20151216162653 payment_time : 173006 payment_date : 20151216 response_code : 00 payment_certificate : 56a3b5d6d2a0 authorisation_id : 065252 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 10993 customer_email : g.demontoux01@compagnons-du-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 = "10994" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10994" select * from cotisations where identifiant = "m.leveque04" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173115 payment_means : VISA transmission_date : 20151216163115 payment_time : 173219 payment_date : 20151216 response_code : 00 payment_certificate : f35cb36887d2 authorisation_id : 191553 currency_code : 978 card_number : 4971.61 cvv_flag : 1 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.demontoux01 order_id : 10994 customer_email : g.demontoux01@compagnons-du-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 = "10995" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10995" select * from cotisations where identifiant = "s.best29" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173846 payment_means : VISA transmission_date : 20151216163846 payment_time : 174005 payment_date : 20151216 response_code : 00 payment_certificate : 28d4218a13d9 authorisation_id : 147596 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 10995 customer_email : g.demontoux01@compagnons-du-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 = "10996" select * from cms_frontusers where identifiant = "a.bonnaterre07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10996" select * from cotisations where identifiant = "a.bonnaterre07" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 173920 payment_means : VISA transmission_date : 20151216163920 payment_time : 174051 payment_date : 20151216 response_code : 00 payment_certificate : 8ae538dfdbf6 authorisation_id : 299925 currency_code : 978 card_number : 4971.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 : a.bonnaterre07 order_id : 10996 customer_email : a.bonnaterre07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201706 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 174108 payment_means : MASTERCARD transmission_date : 20151216164108 payment_time : 174305 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.34 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.goujard17 order_id : 10997 customer_email : d.goujard17@compagnons-du-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 = "10998" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10998" select * from cotisations where identifiant = "c.poirierditcaulie11 " and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175136 payment_means : VISA transmission_date : 20151216165136 payment_time : 175340 payment_date : 20151216 response_code : 00 payment_certificate : 117751b6f6f9 authorisation_id : 503451 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 10998 customer_email : g.demontoux01@compagnons-du-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 = "10999" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "10999" select * from cotisations where identifiant = "f.astro17" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "f.astro17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 175644 payment_means : VISA transmission_date : 20151216165644 payment_time : 175857 payment_date : 20151216 response_code : 00 payment_certificate : b615e39b2e39 authorisation_id : 042215 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 10999 customer_email : g.demontoux01@compagnons-du-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 = "11000" select * from cms_frontusers where identifiant = "g.demontoux01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11000" select * from cotisations where identifiant = "f.antoine27" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175946 payment_means : VISA transmission_date : 20151216165946 payment_time : 180057 payment_date : 20151216 response_code : 00 payment_certificate : d27ae2f1be59 authorisation_id : 261359 currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 11000 customer_email : g.demontoux01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 180927 payment_means : VISA transmission_date : 20151216170927 payment_time : 181044 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 11001 customer_email : g.demontoux01@compagnons-du-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 = "11002" select * from cms_frontusers where identifiant = "f.violeau07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11002" select * from cotisations where identifiant = "f.violeau07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 183823 payment_means : VISA transmission_date : 20151216173823 payment_time : 184006 payment_date : 20151216 response_code : 00 payment_certificate : 8a6917e27c5c authorisation_id : 696262 currency_code : 978 card_number : 4978.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 : f.violeau07 order_id : 11002 customer_email : f.violeau07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_ERROR statement_reference : card_validity : 201805 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11003" select * from cms_frontusers where identifiant = "d.bourget02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11003" select * from cotisations where identifiant = "d.bourget02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183934 payment_means : MASTERCARD transmission_date : 20151216173934 payment_time : 184201 payment_date : 20151216 response_code : 00 payment_certificate : e685b4315093 authorisation_id : 102003 currency_code : 978 card_number : 5137.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 : d.bourget02 order_id : 11003 customer_email : d.bourget02@compagnons-du-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 = "11004" select * from cms_frontusers where identifiant = "f.terrien24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11004" select * from cotisations where identifiant = "f.terrien24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185057 payment_means : MASTERCARD transmission_date : 20151216175057 payment_time : 185314 payment_date : 20151216 response_code : 00 payment_certificate : aa4d51bdf16d authorisation_id : 725645 currency_code : 978 card_number : 5138.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 : f.terrien24 order_id : 11004 customer_email : f.terrien24@compagnons-du-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 : 185712 payment_means : VISA transmission_date : 20151216175712 payment_time : 185830 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 11005 customer_email : g.demontoux01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185841 payment_means : VISA transmission_date : 20151216175841 payment_time : 190022 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 11005 customer_email : g.demontoux01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191035 payment_means : VISA transmission_date : 20151216181035 payment_time : 191200 payment_date : 20151216 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.49 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 02 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.demontoux01 order_id : 11006 customer_email : g.demontoux01@compagnons-du-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 = "11007" select * from cms_frontusers where identifiant = "c.renault24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11007" select * from cotisations where identifiant = "c.renault24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191234 payment_means : MASTERCARD transmission_date : 20151216181234 payment_time : 191547 payment_date : 20151216 response_code : 00 payment_certificate : abf37557af8e authorisation_id : 694193 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 : c.renault24 order_id : 11007 customer_email : c.renault24@compagnons-du-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 = "11008" select * from cms_frontusers where identifiant = "d.villedieu17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11008" select * from cotisations where identifiant = "a.guertin25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191615 payment_means : VISA transmission_date : 20151216181615 payment_time : 191818 payment_date : 20151216 response_code : 00 payment_certificate : 8f69a8ff39dc authorisation_id : 407591 currency_code : 978 card_number : 4201.52 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : d.villedieu17 order_id : 11008 customer_email : d.villedieu17@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11010" select * from cms_frontusers where identifiant = "j.yorg02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11010" select * from cotisations where identifiant = "j.yorg02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195523 payment_means : MASTERCARD transmission_date : 20151216185523 payment_time : 195653 payment_date : 20151216 response_code : 00 payment_certificate : a4b5adc290d6 authorisation_id : 151002 currency_code : 978 card_number : 5612.66 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.yorg02 order_id : 11010 customer_email : j.yorg02@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195502 payment_means : MASTERCARD transmission_date : 20151216185502 payment_time : 195823 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.lefevre03 order_id : 11009 customer_email : jp.lefevre03@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 = "11013" select * from cms_frontusers where identifiant = "f.gos09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11013" select * from cotisations where identifiant = "f.gos09" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195918 payment_means : VISA transmission_date : 20151216185918 payment_time : 200026 payment_date : 20151216 response_code : 00 payment_certificate : e70bdc158346 authorisation_id : 943256 currency_code : 978 card_number : 4975.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.gos09 order_id : 11013 customer_email : f.gos09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 195839 payment_means : MASTERCARD transmission_date : 20151216185839 payment_time : 200204 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.lefevre03 order_id : 11009 customer_email : jp.lefevre03@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 = "11012" select * from cms_frontusers where identifiant = "r.breda28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11012" select * from cotisations where identifiant = "r.breda28" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195911 payment_means : VISA transmission_date : 20151216185911 payment_time : 200206 payment_date : 20151216 response_code : 00 payment_certificate : a19022f26b01 authorisation_id : 267255 currency_code : 978 card_number : 4978.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.breda28 order_id : 11012 customer_email : r.breda28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 200209 payment_means : MASTERCARD transmission_date : 20151216190209 payment_time : 200340 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jp.lefevre03 order_id : 11009 customer_email : jp.lefevre03@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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 195854 payment_means : VISA transmission_date : 20151216185854 payment_time : 200428 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : r.vee31 order_id : 11011 customer_email : r.vee31@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 : 201701 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 : 200253 payment_means : MASTERCARD transmission_date : 20151216190253 payment_time : 190727 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : cvv_flag : cvv_response_code : bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.cavory10 order_id : 11014 customer_email : m.cavory10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : SSL statement_reference : card_validity : score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11015" select * from cms_frontusers where identifiant = "j.ramel31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11015" select * from cotisations where identifiant = "n.guedouar08" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201108 payment_means : VISA transmission_date : 20151216191108 payment_time : 201305 payment_date : 20151216 response_code : 00 payment_certificate : dbfeaba5c980 authorisation_id : 874178 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.ramel31 order_id : 11015 customer_email : j.ramel31@compagnons-du-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 = "11016" select * from cms_frontusers where identifiant = "c.dhaussy02" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11016" select * from cotisations where identifiant = "c.dhaussy02" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201259 payment_means : MASTERCARD transmission_date : 20151216191259 payment_time : 201421 payment_date : 20151216 response_code : 00 payment_certificate : 4845b87fa16f authorisation_id : 515253 currency_code : 978 card_number : 5131.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 : c.dhaussy02 order_id : 11016 customer_email : c.dhaussy02@compagnons-du-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 = "11018" select * from cms_frontusers where identifiant = "g.bertrand30" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11018" select * from cotisations where identifiant = "g.bertrand30" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 202644 payment_means : VISA transmission_date : 20151216192644 payment_time : 202825 payment_date : 20151216 response_code : 00 payment_certificate : 08d800dd4151 authorisation_id : 485455 currency_code : 978 card_number : 4970.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.bertrand30 order_id : 11018 customer_email : g.bertrand30@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11020" select * from cms_frontusers where identifiant = "r.roussel03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11020" select * from cotisations where identifiant = "s.rouch01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 203512 payment_means : MASTERCARD transmission_date : 20151216193512 payment_time : 203651 payment_date : 20151216 response_code : 00 payment_certificate : 75e2e1e74d10 authorisation_id : 672955 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 : r.roussel03 order_id : 11020 customer_email : r.roussel03@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204041 payment_means : MASTERCARD transmission_date : 20151216194041 payment_time : 204158 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5341.86 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : o.amestoy09 order_id : 11021 customer_email : o.amestoy09@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 = "11022" select * from cms_frontusers where identifiant = "b.jitten20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11022" select * from cotisations where identifiant = "b.jitten20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204204 payment_means : MASTERCARD transmission_date : 20151216194204 payment_time : 204428 payment_date : 20151216 response_code : 00 payment_certificate : 1f6d34f64abd authorisation_id : 105327 currency_code : 978 card_number : 5131.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 : b.jitten20 order_id : 11022 customer_email : b.jitten20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11025" select * from cms_frontusers where identifiant = "j.fabbri25" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11025" select * from cotisations where identifiant = "j.fabbri25" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205849 payment_means : VISA transmission_date : 20151216195849 payment_time : 210324 payment_date : 20151216 response_code : 00 payment_certificate : e72f63e3b7f8 authorisation_id : 043158 currency_code : 978 card_number : 4973.58 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.fabbri25 order_id : 11025 customer_email : j.fabbri25@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201803 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "11027" select * from cms_frontusers where identifiant = "j.huck03" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11027" select * from cotisations where identifiant = "j.huck03" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 212420 payment_means : VISA transmission_date : 20151216202420 payment_time : 212611 payment_date : 20151216 response_code : 00 payment_certificate : 1a08dc89b24b authorisation_id : 305575 currency_code : 978 card_number : 4978.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 : j.huck03 order_id : 11027 customer_email : j.huck03@compagnons-du-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 = "11029" select * from cms_frontusers where identifiant = "j.guillaume06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11029" select * from cotisations where identifiant = "j.guillaume06" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 213132 payment_means : VISA transmission_date : 20151216203132 payment_time : 213249 payment_date : 20151216 response_code : 00 payment_certificate : cc42ca1a0eca authorisation_id : 484613 currency_code : 978 card_number : 4974.46 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.guillaume06 order_id : 11029 customer_email : j.guillaume06@compagnons-du-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 = "11030" select * from cms_frontusers where identifiant = "c.moreau19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11030" select * from cotisations where identifiant = "c.moreau19" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214752 payment_means : MASTERCARD transmission_date : 20151216204752 payment_time : 214948 payment_date : 20151216 response_code : 00 payment_certificate : 68066b2a6be9 authorisation_id : 040164 currency_code : 978 card_number : 5341.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : c.moreau19 order_id : 11030 customer_email : c.moreau19@compagnons-du-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 = "11031" select * from cms_frontusers where identifiant = "f.raison01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "11031" select * from cotisations where identifiant = "f.raison01" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "f.raison01" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 215551 payment_means : MASTERCARD transmission_date : 20151216205551 payment_time : 220055 payment_date : 20151216 response_code : 00 payment_certificate : badbda8ead1f authorisation_id : 454554 currency_code : 978 card_number : 5131.17 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.raison01 order_id : 11031 customer_email : f.raison01@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 224133 payment_means : MASTERCARD transmission_date : 20151216214133 payment_time : 224338 payment_date : 20151216 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.94 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.luzak11 order_id : 11034 customer_email : g.luzak11@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 : 201701 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------