Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 004555 payment_means : MASTERCARD transmission_date : 20161107234555 payment_time : 004954 payment_date : 20161107 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5136.59 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.mariat05 order_id : 15555 customer_email : a.mariat05@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 = "15556" select * from cms_frontusers where identifiant = "j.guiol23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15556" select * from cotisations where identifiant = "j.guiol23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 064847 payment_means : VISA transmission_date : 20161108054847 payment_time : 065021 payment_date : 20161108 response_code : 00 payment_certificate : 57aa09b4f83a authorisation_id : 334840 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 : j.guiol23 order_id : 15556 customer_email : j.guiol23@compagnons-du-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 = "15558" select * from cms_frontusers where identifiant = "b.fournier27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15558" select * from cotisations where identifiant = "b.fournier27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075519 payment_means : VISA transmission_date : 20161108065519 payment_time : 075642 payment_date : 20161108 response_code : 00 payment_certificate : 1504f9e9557b authorisation_id : 782068 currency_code : 978 card_number : 4970.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 : b.fournier27 order_id : 15558 customer_email : b.fournier27@compagnons-du-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 = "15557" select * from cms_frontusers where identifiant = "t.hannier20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15557" select * from cotisations where identifiant = "t.hannier20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 075512 payment_means : MASTERCARD transmission_date : 20161108065512 payment_time : 075741 payment_date : 20161108 response_code : 00 payment_certificate : 80a0f50ee515 authorisation_id : 535171 currency_code : 978 card_number : 5133.70 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.hannier20 order_id : 15557 customer_email : t.hannier20@compagnons-du-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 = "15559" select * from cms_frontusers where identifiant = "m.bellanger05" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15559" select * from cotisations where identifiant = "m.bellanger05" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 082919 payment_means : VISA transmission_date : 20161108072919 payment_time : 083313 payment_date : 20161108 response_code : 00 payment_certificate : cae3ca08926a authorisation_id : 024496 currency_code : 978 card_number : 4059.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 : m.bellanger05 order_id : 15559 customer_email : m.bellanger05@compagnons-du-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 = "15560" select * from cms_frontusers where identifiant = "f.buonomo18" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15560" select * from cotisations where identifiant = "f.buonomo18" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 093741 payment_means : VISA transmission_date : 20161108083741 payment_time : 093906 payment_date : 20161108 response_code : 00 payment_certificate : a7fd45c97bd6 authorisation_id : 994977 currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.buonomo18 order_id : 15560 customer_email : f.buonomo18@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15562" select * from cms_frontusers where identifiant = "p.doyharcabal21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15562" select * from cotisations where identifiant = "p.doyharcabal21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102651 payment_means : MASTERCARD transmission_date : 20161108092651 payment_time : 102924 payment_date : 20161108 response_code : 00 payment_certificate : 1e929603bbe9 authorisation_id : 123165 currency_code : 978 card_number : 5137.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.doyharcabal21 order_id : 15562 customer_email : p.doyharcabal21@compagnons-du-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 = "15564" select * from cms_frontusers where identifiant = "p.claviere22" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15564" select * from cotisations where identifiant = "p.claviere22" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 135826 payment_means : MASTERCARD transmission_date : 20161108125826 payment_time : 140606 payment_date : 20161108 response_code : 00 payment_certificate : c879a85425f4 authorisation_id : 413456 currency_code : 978 card_number : 5131.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 : p.claviere22 order_id : 15564 customer_email : p.claviere22@compagnons-du-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 = "15565" select * from cms_frontusers where identifiant = "p.chemin20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15565" select * from cotisations where identifiant = "p.chemin20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 145500 payment_means : VISA transmission_date : 20161108135500 payment_time : 145613 payment_date : 20161108 response_code : 00 payment_certificate : 9e4a83bd5b51 authorisation_id : 542103 currency_code : 978 card_number : 4978.09 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.chemin20 order_id : 15565 customer_email : p.chemin20@compagnons-du-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 = "15566" select * from cms_frontusers where identifiant = "m.brischoux13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15566" select * from cotisations where identifiant = "m.brischoux13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 152332 payment_means : MASTERCARD transmission_date : 20161108142332 payment_time : 152701 payment_date : 20161108 response_code : 00 payment_certificate : 24d9e273218a authorisation_id : 281842 currency_code : 978 card_number : 5137.80 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.brischoux13 order_id : 15566 customer_email : m.brischoux13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15567" select * from cms_frontusers where identifiant = "m.brischoux13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15567" select * from cotisations where identifiant = "o.gachet20" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 153044 payment_means : VISA transmission_date : 20161108143044 payment_time : 153310 payment_date : 20161108 response_code : 00 payment_certificate : 11fd40800090 authorisation_id : 521863 currency_code : 978 card_number : 4978.28 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.brischoux13 order_id : 15567 customer_email : m.brischoux13@compagnons-du-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 = "15568" select * from cms_frontusers where identifiant = "md.laude21" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15568" select * from cotisations where identifiant = "md.laude21" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "md.laude21" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 164956 payment_means : VISA transmission_date : 20161108154956 payment_time : 165101 payment_date : 20161108 response_code : 00 payment_certificate : daf428276e9a authorisation_id : 641466 currency_code : 978 card_number : 4970.30 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : md.laude21 order_id : 15568 customer_email : md.laude21@compagnons-du-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 = "15570" select * from cms_frontusers where identifiant = "p.roinard04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15570" select * from cotisations where identifiant = "p.roinard04" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 172824 payment_means : MASTERCARD transmission_date : 20161108162824 payment_time : 173217 payment_date : 20161108 response_code : 00 payment_certificate : 6faccba12e8d authorisation_id : 548754 currency_code : 978 card_number : 5130.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 : p.roinard04 order_id : 15570 customer_email : p.roinard04@compagnons-du-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 = "15571" select * from cms_frontusers where identifiant = "f.aucoulon07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15571" select * from cotisations where identifiant = "f.aucoulon07" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175433 payment_means : VISA transmission_date : 20161108165433 payment_time : 175615 payment_date : 20161108 response_code : 00 payment_certificate : f7abb6c1d8d4 authorisation_id : 695177 currency_code : 978 card_number : 4974.21 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.aucoulon07 order_id : 15571 customer_email : f.aucoulon07@compagnons-du-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 = "15572" select * from cms_frontusers where identifiant = "g.kodische06" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15572" select * from cotisations where identifiant = "g.kodische06" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181200 payment_means : VISA transmission_date : 20161108171200 payment_time : 181434 payment_date : 20161108 response_code : 00 payment_certificate : cec0b3f7e2a6 authorisation_id : 555447 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 : g.kodische06 order_id : 15572 customer_email : g.kodische06@compagnons-du-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 = "15573" select * from cms_frontusers where identifiant = "s.dommange28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15573" select * from cotisations where identifiant = "s.dommange28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181358 payment_means : VISA transmission_date : 20161108171358 payment_time : 181817 payment_date : 20161108 response_code : 00 payment_certificate : 816499837acf authorisation_id : 965419 currency_code : 978 card_number : 4978.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 : s.dommange28 order_id : 15573 customer_email : s.dommange28@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201910 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15574" select * from cms_frontusers where identifiant = "b.flin14" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15574" select * from cotisations where identifiant = "b.flin14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 181819 payment_means : MASTERCARD transmission_date : 20161108171819 payment_time : 182120 payment_date : 20161108 response_code : 00 payment_certificate : 2e5e9cfcafbf authorisation_id : 722675 currency_code : 978 card_number : 5137.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 : b.flin14 order_id : 15574 customer_email : b.flin14@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201903 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 182807 payment_means : VISA transmission_date : 20161108172807 payment_time : 182944 payment_date : 20161108 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.67 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 : p.kabala24 order_id : 15575 customer_email : p.kabala24@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 : 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 : 183006 payment_means : VISA transmission_date : 20161108173006 payment_time : 183155 payment_date : 20161108 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4533.67 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 : p.kabala24 order_id : 15575 customer_email : p.kabala24@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 : 201811 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15575" select * from cms_frontusers where identifiant = "p.kabala24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15575" select * from cotisations where identifiant = "p.kabala24" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 183156 payment_means : MASTERCARD transmission_date : 20161108173156 payment_time : 183431 payment_date : 20161108 response_code : 00 payment_certificate : e3031dbd6134 authorisation_id : 369233 currency_code : 978 card_number : 5132.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : p.kabala24 order_id : 15575 customer_email : p.kabala24@compagnons-du-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 = "15578" select * from cms_frontusers where identifiant = "m.leguenic01" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15578" select * from cotisations where identifiant = "m.leguenic01" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 200837 payment_means : VISA transmission_date : 20161108190837 payment_time : 201030 payment_date : 20161108 response_code : 00 payment_certificate : 46103bace3a8 authorisation_id : 784551 currency_code : 978 card_number : 4978.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.leguenic01 order_id : 15578 customer_email : m.leguenic01@compagnons-du-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 : 200805 payment_means : MASTERCARD transmission_date : 20161108190805 payment_time : 201033 payment_date : 20161108 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5817.82 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.sabadach09 order_id : 15577 customer_email : a.sabadach09@compagnons-du-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 = "15579" select * from cms_frontusers where identifiant = "j.boesch27" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15579" select * from cotisations where identifiant = "j.boesch27" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201116 payment_means : VISA transmission_date : 20161108191116 payment_time : 201307 payment_date : 20161108 response_code : 00 payment_certificate : bc4b99cc55b3 authorisation_id : 242052 currency_code : 978 card_number : 4978.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 : j.boesch27 order_id : 15579 customer_email : j.boesch27@compagnons-du-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 : 201052 payment_means : MASTERCARD transmission_date : 20161108191052 payment_time : 201327 payment_date : 20161108 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5817.82 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.sabadach09 order_id : 15577 customer_email : a.sabadach09@compagnons-du-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 = "15581" select * from cms_frontusers where identifiant = "jm.ducastel13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15581" select * from cotisations where identifiant = "jm.ducastel13" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 201456 payment_means : MASTERCARD transmission_date : 20161108191456 payment_time : 201700 payment_date : 20161108 response_code : 00 payment_certificate : ff84d3c33280 authorisation_id : 539160 currency_code : 978 card_number : 5131.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 : jm.ducastel13 order_id : 15581 customer_email : jm.ducastel13@compagnons-du-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 = "15580" select * from cms_frontusers where identifiant = "a.chollet09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15580" select * from cotisations where identifiant = "a.diaz11" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 201305 payment_means : VISA transmission_date : 20161108191305 payment_time : 201853 payment_date : 20161108 response_code : 00 payment_certificate : d42a48ab8d88 authorisation_id : 008338 currency_code : 978 card_number : 4659.85 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.chollet09 order_id : 15580 customer_email : a.chollet09@compagnons-du-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 = "15584" select * from cms_frontusers where identifiant = "t.wasselin17" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15584" select * from cotisations where identifiant = "t.wasselin17" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "t.wasselin17" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 202506 payment_means : MASTERCARD transmission_date : 20161108192506 payment_time : 202924 payment_date : 20161108 response_code : 00 payment_certificate : 82660d32889a authorisation_id : 420229 currency_code : 978 card_number : 5131.39 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.wasselin17 order_id : 15584 customer_email : t.wasselin17@compagnons-du-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 = "15586" select * from cms_frontusers where identifiant = "e.coreau15" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15586" select * from cotisations where identifiant = "e.coreau15" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203501 payment_means : VISA transmission_date : 20161108193501 payment_time : 203710 payment_date : 20161108 response_code : 00 payment_certificate : a456894260bb authorisation_id : 162923 currency_code : 978 card_number : 4970.99 cvv_flag : 1 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.coreau15 order_id : 15586 customer_email : e.coreau15@compagnons-du-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 = "15585" select * from cms_frontusers where identifiant = "c.leduc26" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15585" select * from cotisations where identifiant = "c.leduc26" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 203252 payment_means : VISA transmission_date : 20161108193252 payment_time : 203752 payment_date : 20161108 response_code : 00 payment_certificate : 69a469769e87 authorisation_id : 096304 currency_code : 978 card_number : 4978.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 : c.leduc26 order_id : 15585 customer_email : c.leduc26@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201909 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204517 payment_means : MASTERCARD transmission_date : 20161108194517 payment_time : 204726 payment_date : 20161108 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5817.82 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.sabadach09 order_id : 15587 customer_email : a.sabadach09@compagnons-du-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 = "15588" select * from cms_frontusers where identifiant = "v.nouvellon24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15588" select * from cotisations where identifiant = "v.nouvellon24" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204534 payment_means : MASTERCARD transmission_date : 20161108194534 payment_time : 204802 payment_date : 20161108 response_code : 00 payment_certificate : cda4eb1067b9 authorisation_id : 241361 currency_code : 978 card_number : 5341.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 : v.nouvellon24 order_id : 15588 customer_email : v.nouvellon24@compagnons-du-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 = "15589" select * from cms_frontusers where identifiant = "d.genois08" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15589" select * from cotisations where identifiant = "d.genois08" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204556 payment_means : VISA transmission_date : 20161108194556 payment_time : 204936 payment_date : 20161108 response_code : 00 payment_certificate : 763d98fd43bf authorisation_id : 168231 currency_code : 978 card_number : 4978.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 : d.genois08 order_id : 15589 customer_email : d.genois08@compagnons-du-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 = "15590" select * from cms_frontusers where identifiant = "y.trehorel31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15590" select * from cotisations where identifiant = "y.trehorel31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 204803 payment_means : MASTERCARD transmission_date : 20161108194803 payment_time : 205059 payment_date : 20161108 response_code : 00 payment_certificate : f90e7bea3201 authorisation_id : 824826 currency_code : 978 card_number : 5132.47 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : y.trehorel31 order_id : 15590 customer_email : y.trehorel31@compagnons-du-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 = "15591" select * from cms_frontusers where identifiant = "p.dabbadie09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15591" select * from cotisations where identifiant = "p.dabbadie09" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205654 payment_means : MASTERCARD transmission_date : 20161108195654 payment_time : 205830 payment_date : 20161108 response_code : 00 payment_certificate : 985e4fc800a7 authorisation_id : 405282 currency_code : 978 card_number : 5131.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 : p.dabbadie09 order_id : 15591 customer_email : p.dabbadie09@compagnons-du-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 : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 205900 payment_means : MASTERCARD transmission_date : 20161108195900 payment_time : 210210 payment_date : 20161108 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5137.12 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 : b.verot27 order_id : 15592 customer_email : b.verot27@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201808 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "15593" select * from cms_frontusers where identifiant = "l.brethenoux12" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15593" select * from cotisations where identifiant = "l.brethenoux12" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 210701 payment_means : MASTERCARD transmission_date : 20161108200701 payment_time : 210925 payment_date : 20161108 response_code : 00 payment_certificate : 5226bfa4224e authorisation_id : 016351 currency_code : 978 card_number : 5131.84 cvv_flag : 1 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.brethenoux12 order_id : 15593 customer_email : l.brethenoux12@compagnons-du-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 = "15594" select * from cms_frontusers where identifiant = "jl.quesnot23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15594" select * from cotisations where identifiant = "jl.quesnot23" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211051 payment_means : MASTERCARD transmission_date : 20161108201051 payment_time : 211337 payment_date : 20161108 response_code : 00 payment_certificate : cc0e22849f74 authorisation_id : 543733 currency_code : 978 card_number : 5137.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 : jl.quesnot23 order_id : 15594 customer_email : jl.quesnot23@compagnons-du-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 = "15595" select * from cms_frontusers where identifiant = "p.dabbadie09" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15595" select * from cotisations where identifiant = "m.lambert14" and annee = "2016" and montant <> 0 select * from cotisations where identifiant = "m.lambert14" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211202 payment_means : VISA transmission_date : 20161108201202 payment_time : 211530 payment_date : 20161108 response_code : 00 payment_certificate : 001c4582ae61 authorisation_id : 5066 currency_code : 978 card_number : 4970.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.dabbadie09 order_id : 15595 customer_email : p.dabbadie09@compagnons-du-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 = "15597" select * from cms_frontusers where identifiant = "t.leone19" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15597" select * from cotisations where identifiant = "t.leone19" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 214200 payment_means : VISA transmission_date : 20161108204200 payment_time : 214325 payment_date : 20161108 response_code : 00 payment_certificate : 52e6f94fe7d8 authorisation_id : 339044 currency_code : 978 card_number : 4978.01 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : t.leone19 order_id : 15597 customer_email : t.leone19@compagnons-du-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 = "15599" select * from cms_frontusers where identifiant = "mt.mavel31" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15599" select * from cotisations where identifiant = "mt.mavel31" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 221826 payment_means : VISA transmission_date : 20161108211826 payment_time : 222116 payment_date : 20161108 response_code : 00 payment_certificate : 944354ac5248 authorisation_id : 021154 currency_code : 978 card_number : 4929.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 : mt.mavel31 order_id : 15599 customer_email : mt.mavel31@compagnons-du-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 = "15600" select * from cms_frontusers where identifiant = "m.fernandez11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15600" select * from cotisations where identifiant = "m.fernandez11" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 222633 payment_means : MASTERCARD transmission_date : 20161108212633 payment_time : 222925 payment_date : 20161108 response_code : 00 payment_certificate : b2dd0f516ae6 authorisation_id : 102831 currency_code : 978 card_number : 5131.83 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.fernandez11 order_id : 15600 customer_email : m.fernandez11@compagnons-du-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 = "15601" select * from cms_frontusers where identifiant = "j.verbiguie16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15601" select * from cotisations where identifiant = "j.verbiguie16" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 223949 payment_means : VISA transmission_date : 20161108213949 payment_time : 224114 payment_date : 20161108 response_code : 00 payment_certificate : e3d4f2148034 authorisation_id : 550152 currency_code : 978 card_number : 4698.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 : j.verbiguie16 order_id : 15601 customer_email : j.verbiguie16@compagnons-du-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 = "15602" select * from cms_frontusers where identifiant = "p.dupuy28" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "15602" select * from cotisations where identifiant = "p.dupuy28" and annee = "2017" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 230506 payment_means : MASTERCARD transmission_date : 20161108220506 payment_time : 230852 payment_date : 20161108 response_code : 00 payment_certificate : eafdaf9de4da authorisation_id : 054431 currency_code : 978 card_number : 5134.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 : p.dupuy28 order_id : 15602 customer_email : p.dupuy28@compagnons-du-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 : -------------------------------------------